Hi....

I am getting the problem while I am run the following query in Visual Basic.

Table name : Rel
Database : Access
ad : ADO connection
rd : ADO Recordset

I am trying to retriving the records from table when I click the combo box.


rd.open "Select Department,Gono,Godate,Amtrel from Rel where department = " & combo1.text, ad

error is : Syntex error (missing operator) in query expression

kindly any body can help me to solve this problem. my email-id is superman_mukkamala@yahoo.co.in

Thank-U
Sangameshwar

rd.open "Select Department,Gono,Godate,Amtrel from Rel where department LIKE " & combo1.text, ad