Query by form - Need Help with SQL

[allcarfan]

I am using a query by for technique that generates a report. I have 5 fields that are combo boxes on the form that designates what criteria is to be queried. When the information is input into the fields, the query and the report work GREAT. However, I want to be able to leave fields blank and it pull back ALL criteria.

Example:

I have a drop down box that lists Team Names. I want to be able to leave that combo box empty and the query pull back information for ALL Teams.


I have succesfully implemented this on another database that I created, but I cannot, for the life of me, remember how I did it. Even looking at the structure of that database, I still cant remember.

 

[mp9]

You may find

http://www22.brinkster.com/accessory/forms/007.shtml

helpful, as it shows how to add an "ALL" option to the top of your combo boxes.

 

[allcarfan]

I appreciate the link. However, I cannot seem to get that to work in this particular form. I have approached it from every possible angle. Even cutting, pasting, and renaming the code as provided in the brinkster link.

Any other ideas?