Query with multiple user defined parameters

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

Hi -

I have been spending much time with the below problem:

I have an application with six user defined combo boxes
where the user will be able to select parameters from pull
down menus.

However, the user has the choice of either selecting or
leaving any of the 6 combo boxes blank.

If they do leave any one blank, I want my query to pull
all information for that particular parameter.

Does this make sense? How can I do these without having a
bunch of If/Else If statements?

Please let me know.
Thanks!
 
Leo,

The criteria in your query should look like:

Like Forms![FormName].[cboName1] & "*"

This will work the way you want it, pulling all records if
Forms![FormName].[cboName1] = ""

HTH,
Nikos
 
Back
Top