multiple search criteria

[vinux]

Hi,

I have a form on which I have about 6 combo-boxes and a set of 3 radio buttons.

I'm to the point that all the querys that fill these combo-boxes are in place.


What I want now is a search button that updates a datagrid under it when clicked. The query in this datagrid needs to be parameterised with the selected values in the comboboxes or radio buttons.
It should be possible to only select one combobox before pressing update.

At this point I placed a subform in the form to bind this query to. ( the datagrid I need).
Is a subform the correct object for this or are there other possibilities?

For some boxes only a line to the where clausule of the SQL statement needs to be added. For some other (one) and the radio buttons a join needs to be made with another table.
So I will have to build my sql statement dynamicaly in some vba code, run it when the search button is clicked and refresh the datagrid.

Does ab has a sample database in which such a search form is being used?

I must have downloaded like 10 sample DB's now but nothing I can use...

all help or advise greetly appreciated.

 

[Birdy]

Instead of a Subform....

Use a Text box to create your query upon clicking the button.

I will try and find and example of this for you. Just need to remember which of the db's I support uses it.

 

[ejstefl]

Check out these links:

http://www.fontstuff.com/access/acctut17.htm

http://www.fontstuff.com/access/acctut18.htm

 

[Birdy]

Here is the example form that I mentioned

Just look at the attachment.