Recordset Criteria

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset Criteria 0
Access 2003 and SQL Server 2005 and DAO recordset 1
Recordsets-Old and New 5
filling unbound form 1
Using SQL Query Code in Form Module to Return Record Count 2
Using "tiles" 1
Reset a recordset? 2
Assign recordset - subform 1

Top