Queries based on user input on form

  • Thread starter Thread starter Robert Cs.
  • Start date Start date
R

Robert Cs.

I have built a select query that responds to the user's
selection/input on a form. The input boxes are made from three combo
boxes, which look up data from a table. All works alright, except for
one thing. If any of the combo boxes is left blank (ie. untouched, no
data selected), the query returns without results, where what I would
like to see exactly the opposite, meaning is nothing is selected in
the combo box, it would mean "select all" for the query.

I am sure the solution is right front of me, but I am not seeing it..

Your help is much appreciated,
Robert
 
Hi, Robert:

Try reviewing Microsoft Knowledge Base Article 304428--"How to Use the Query
by Form Technique" available on the Microsoft website. I just learned to
set up a form similar to yours, and the article kept me on the right track.

I'm not sure exactly how you'r form is set up, but I suspect it's something
about the blank fields v. null values.

Hope this helps!

Ramona
 
Back
Top