Query from form

[Ty]

How can I create a query that runs through multiple
fields of a form, but does not require each field to
contain information for the search. Each time I try to
make the query, it comes up empty because I do not enter
information in every field. I want to be able to click
search after entering all the information I want to
search for, and the query pull up records with the
information I am looking for. Does that make since?

 

[[MVP] S. Clark]

WHERE field1 LIKE "*" & forms!frmName!txtField1 AND ...

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-