query

[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 Herlihy]

This problem gets a bit involved, as users may leave boxes blank and your
form needs to allow for this. There's a useful treatment of the problem
here:
http://allenbrowne.com/ser-62.html

Phil, London

 

[awsmitty]

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

 

[Philip Herlihy]

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