Using Form to populate query criteria

  • Thread starter Thread starter mbmccoy
  • Start date Start date
M

mbmccoy

I hope I can explain this accurately. I have built a form to run a query.
The form consists of 4 combo boxes that act as the selection criteria for
the query. Each combo box is tied to a seperate table for look up. I tied
the form to the query and all is well. Everything works as it should...
EXCEPT.

A). I have to populate all of the combo boxes in order for the query to
run. I need be able to have the option of leaving any of the combo box
selection blank. As a default to return ALL (no criteria selection).

B). I would also like the option of choosing more than one item from each
combo box.

I think "B" goes beyond my skills but "A" is the by far most important.

Mark
 
mbmccoy said:
I hope I can explain this accurately. I have built a form to run a query.
The form consists of 4 combo boxes that act as the selection criteria for
the query. Each combo box is tied to a seperate table for look up. I tied
the form to the query and all is well. Everything works as it should...
EXCEPT.

A). I have to populate all of the combo boxes in order for the query to
run. I need be able to have the option of leaving any of the combo box
selection blank. As a default to return ALL (no criteria selection).

B). I would also like the option of choosing more than one item from each
combo box.

I think "B" goes beyond my skills but "A" is the by far most important.

Mark
Click to expand...

Mark,

Maybe this page will help you:

http://mvps.org/access/queries/qry0001.htm
 
Back
Top