VB Code:
  1. strSerialNo = "2"
  2. set rsmulti = dbname2.OpenRecordSet("SELECT * FROM Phrase2 where SerialNo = " & strSerialNo & " ",dbOpenDynaset)

can anyone tell me whats wrong with this function ? it cant work