Use 1 form and choose from which query

[gpurger]

Hi,
I have a requirement to filter some queries periodically on the date field.
What I want to do is create a form that lets you choose which query to use and filter and not create alot of single forms.
The filter will be only be applied whilst the form is open.

Cheers

Gordon

 

[maxmangion]

if the sql statements of your query is going to be the same, except for the WHERE part, i would suggest you using a querydef. Alternatively, if you want to use one form for many queries, you can change the recordsource of your form to your required query ... Me.RecordSource = "queryname"

 

[gpurger]

Thanks for that.
Cheers
Gordon

 

[maxmangion]

you're welcome