S
Sean Henry
I need to supply a SQL string for a recordset, and no matter what combination of quotes etc.... I use I cannot get this to work. The field SearchCompanyName is from the form. What am I missing?
Set rst = CurrentDb.OpenRecordset("select * from AddressBook" & _
"where CompanyName=" & SearchCompanyName)
Set rst = CurrentDb.OpenRecordset("select * from AddressBook" & _
"where CompanyName=" & SearchCompanyName)