Query by Form

[jlgray0127]

So...
I have done this before, but do not remember exactly how I did it.
I have a query, where I want a user to be able to enter criteria and look at specific records in a table.
I have built a form to enter the criteria, and am setting a macro to run the query when the data is entered.
The part I'm having trouble remembering how to do, is that I am offering 4 fields to enter criteria. I want them to be able to enter the criteria they want. Field 1, Field 2, Field 3, Field 4, and Field 5. This really drills down specific, but what if we only want to look at the records matching in Field 1 and Field 4, or Field 2 and Field 3 and Field 4.
They need to be able to enter in each field to get to a few records, or only enter a couple fields, to get a more broad selection of records to look through.
Any help will be greatly appreciated! Thank you!

 

[Alansidman]

This should help

http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[jlgray0127]

So... I remembered how to do this!!!! (In 2003), but can not seem to replicate it in 2007.
Here is the criteria in the query I have, (Below) I am getting an error stating "The Microsoft Office Access database engine does not recognize 'Forms!MAIN_MENU!LINE!' as a valid field name or expression." It does this for each field where I entered this criteria, so not sure if it's a 2007 thing or what the deal is. I just recently went to the operating system for 2007.
I have inputted this same equation into 3 different fields, referencing the appropriate fields for each field.

Like "*" & [Forms]![MAIN_MENU]![LINE] & "*" Or Is Null

 

[YNWA]

I use:

Like "*" & [forms]![FRM_SearchMulti3]![SrchText] & "*"