Query By Form Help Needed Please.

[TK]

I have a large table of customers. What I need is a form that I filter out
first all the records that match field "Company Name", the continue to
filter out from this list all records that match field "Salesman" and
finally continue to filter the list down by field "Date". So far, the only
thing I can figure out is a form with a combo box on it to choose the
"Company Name" with a subform that then displays all matching records, but
I'm stuck on how to go any further.

Any suggestions would be greatly appreciated.

Thanks

 

[MacDermott]

Have you looked at Access's built-in Query By Form feature?
If you really want to do it step-by-step, you could use Query By Selection.

 

[Paul B.]

I did something like this....


Build your form with combo boxes to select your criteria, ie:
cboCompanyName, cboSalesman and cboDate

Then build a query, selecting all the fields you want to display, including
those of your combo boxes.

In the criteria of the fields you just put into the query, put
Forms![FormName].[cboCompanyName] etc...

Then put a command button to open a new form which is bound to the query.

HTH.