Subform Date Help!

  • Thread starter Thread starter chad
  • Start date Start date
C

chad

hello, i have a form that has 5 (five) subforms on it
that are date oriented. i need the subforms to list the
data from the dates i specify. on my query i am using:
[Start Date mm/dd/yy] And <[End Date mm/dd/yy]
Click to expand...

as my criteria. this gives me the info and the days that
i need, but i have to put the dates in 5 times before my
form fully loads. my question is: Is there a way to only
put the dates in once and it pulls the info for all 5
subforms for the dates specified. or am i going to have
to put the dates in 5 times.

please help.

thanks
chad
 
-----Original Message-----
hello, i have a form that has 5 (five) subforms on it
that are date oriented. i need the subforms to list the
data from the dates i specify. on my query i am using:
[Start Date mm/dd/yy] And <[End Date mm/dd/yy]
Click to expand...

as my criteria. this gives me the info and the days that
i need, but i have to put the dates in 5 times before my
form fully loads. my question is: Is there a way to only
put the dates in once and it pulls the info for all 5
subforms for the dates specified. or am i going to have
to put the dates in 5 times.

please help.

thanks
chad
.
Try using a pop-up form with date fields to open the form
Click to expand...
with and then use the date fields of that form as the
criteria for all of the queries. I usually make the pop up
visible false after the user clicks the command button to
open the main form and the put a close command on the main
forms On Unload event to close the pop-up.
 
Back
Top