Multiple Inputs for a Query

[spcepickle]

I have a form that has three different pull down menus. When I click a button on the form it opens a second form that is filtered by a query. In order to allow the user to leave a pull down menu blank the query has 6 different columns. Three are headed with the field name and three are headed with the form reference, under the form reference it either says Is Null or Is Not Null. I have a total of 8 options in order to cover all possible scenarios. I would like to be able to add more search parameters but my query is getting ridicules. Is there a way to build the same thing with a code?

Thanks!

 

[pbaldy]

The sample db in this FAQ shows how to build SQL in code:

http://www.mdbmakers.com/forums/showthread.php?t=4895