Varying a query based on form input

[T Goddard]

Hi Everyone

I have a table of contacts with associated information and would like to
have some way of querying these in a number of ways without having to write
a query for each outcome.

Ideally I would like a form where I can choose a month from a drop-down list
together with a few yes or no choices relating to other fields in the table
and then hit a button to execute a query using these choices as the criteria
(hope this makes sense!). I would like to avoid using square brackets to
prompt for user input if at all possible.

Although I can see that the choices inputted into the form need to be passed
to the query somehow I have no idea where to start. I can already create
the drop-down lists and other form elements, I just don't know how to make
the form content alter the query.

Any help would be appreciated.

Many thanks

Tim.

 

[Michel Walsh]

Hi,


Have you experiment with the FilterByForm built-in possibilities? Check the toolbar, when a form is
open, there are a couple of buttons at that effect.


Hoping it may help,
Vanderghast, Access MVP

 

[T Goddard]

Hi

Thanks for the idea, I'll give it a try...

Tim.