querying with values in combo boxes

[chatfield]

I have a form that is bound to a query. I would like to select a specific record on the form where the values of three of the query fields, e.g., A, B and C, are equal to the values of three combo boxes on the form.

Can you help me?

 

[scriverb]

Try this SQL example. Update with your table name and field names:
Select A.*
FROM tblYourTableName as A
WHERE ((A.A = [Forms]![frmYourFormName]![ComboA]) AND
(A.B = [Forms]![frmYourFormName]![ComboB]) AND
(A.C = [Forms]![frmYourFormName]![ComboC]));

This will select the records using the values from the combobox's.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???