Multiple Queries / Same Criteria

  • Thread starter Thread starter AndrewB
  • Start date Start date
A

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?
 
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
 
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,
 
You're welcome.

Jeff

AndrewB said:
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.


Jeff Boyce said:
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
Click to expand...
Click to expand...
 
Back
Top