T
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.
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.