how to make a multiple criteria search in access 2000

[jlg5454]

I need a form to be able to act just like the filter form page to search on multiple criterias and then to place the results in a subsheet at the bottom of the page. Does anyone know a quick and easy way to do this without using VB. Thanks for any help that you can provide.

 

[SydneyGeek]

Not entirely code-free, but almost!
Subform needs to be based on a query.
Set the criteria for the query to be UNBOUND textboxes on your UNBOUND main form. Search1, Search2, etc.
For each textbox that gets used as a search field, put this in the AfterUpdate event (ie, once the data is in the textbox and you move to another one or otherwise save the data) --
[MySubform].[Form].Requery

That shoudl refresh the data.

Denis

 

[xsnd47]

What if the users will not be using all the criteria all the time? meaning, let's say I have 4 fields that can be searched on, but users can use any 1, 2, 3, or all 4 fields to search. Can I do this?