Form/subform double entry of criteria

[mike]

How can I setup a form and subform getting data from 2 queries with user
entry criteria, and not have to enter the criteria twice when the form opens.


Thanks

 

[Jeff Boyce]

?use identical prompts/paramaters in both queries?

?base query #2 on query #1 and put the parameters in query #1?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

How can I setup a form and subform getting data from 2 queries with user
entry criteria, and not have to enter the criteria twice when the form opens.


Thanks

One way is to use a Form to solicit the parameters, instead of a prompt; e.g.
instead of

[Enter start date:]

have a form (typically unbound, or at least an unbound control) and use a
criterion like

[Forms]![NameOfForm]![NameOfControl]

 

[Adam Milligan]

Mike-

Make a form with a text box on it for your users to enter their criteria.
Then make the critera in both queries something like...

Forms![frmYourForm].[txtYourTextBox]

Hope that helps!

Adam

 

[Adam Milligan]

Mike-

Make a form with a text box on it for your users to enter their cirteria
into. Then make the criteria field in both queries something like this...

Forms!frmYourForm.txtYourTextBox

Where I have written 'txtYourTextBox' make sure to put in the NAME of the
textbox (from the "other" tab on your text box properties)

Hope that is what you were looking for!

Adam