If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Queries / Same Criteria
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? -- AndrewB. |
#2
|
|||
|
|||
Multiple Queries / Same Criteria
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" wrote in message ... 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? -- AndrewB. |
#3
|
|||
|
|||
Multiple Queries / Same Criteria
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" wrote: 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" wrote in message ... 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? -- AndrewB. |
#4
|
|||
|
|||
Multiple Queries / Same Criteria
You're welcome.
Jeff "AndrewB" wrote in message ... 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" wrote: 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" wrote in message ... 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? -- AndrewB. |
Thread Tools | |
Display Modes | |
|
|