Multiple Queries / Same Criteria

[AndrewB]

I have a main form with 4 subforms. The 4 subforms source are 4 individual
queries. When I open the main form I am prompted to enter the
parameters/criteria for each query. The criteria will be the same for each
query (a date range To/From).

Is there a way to only input the To/From criteria 1 time instead of 4
seperate times and have all 4 queries look to the same place for the
parameters?

 

[Jeff Boyce]

A common approach to this is to put two unbound controls on your main form,
and "point" your queries to the main form's (two) controls to get their
parameters.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AndrewB]

Hi Jeff,

Wow! I would have never thought of that. Took a little bit getting the
syntax correct for my criteria but I got it to work. I created 2 unbound
text boxes and created a 'between [] and []' criteria which points to the 2
text boxes.

Really appreciate the assistance!

Thanks again,

 

[Jeff Boyce]

You're welcome.

Jeff

Hi Jeff,

Wow! I would have never thought of that. Took a little bit getting the
syntax correct for my criteria but I got it to work. I created 2 unbound
text boxes and created a 'between [] and []' criteria which points to the
2
text boxes.

Really appreciate the assistance!

Thanks again,

--
AndrewB.

A common approach to this is to put two unbound controls on your main
form,
and "point" your queries to the main form's (two) controls to get their
parameters.

Regards

Jeff Boyce
Microsoft Office/Access MVP