query

  • Thread starter Thread starter awsmitty
  • Start date Start date
A

awsmitty

I have a form that is based on a query. The query searches five different
fields. When I double click on either teh form or the query, five question
boxes appear, one after the other, asking for teh parameters for that field.
How can I construct the form so that these boxes appear on the form, all at
once, and once filled, click a button to perform the search?

Obviously I'm very new to this
 
Philip,

I have looked at this pior to asking, posting here. There are a few other
links that are useful, but I still can't get there, even though I think,
thought, I was, am close
 
There are two approaches.

Filter by Form, and Query by Form. The former is built-in, and might well
do everything you need. See:
http://support.microsoft.com/kb/304259

Query by Form is more complex. You have to build a query which refers to
the value of the boxes ("controls") on your form, and also handles the logic
of the various possibly combinations a user may enter. See:
http://support.microsoft.com/kb/304428

Try both, and then post back with specific problems.

Phil
 
Back
Top