Scooter172
11-25-2011, 01:49 PM
I have a query in access that querys 5 tables for dates off and schedules off.
To display this info I have created a Modal Form that displays based on Parameters and that works fine.
I would rather that form open first and then select the dates that are being queried with two controls that select Start and End dates . These inputs work to and open a seperate query buy placing this in the Criteria of the date column of the query
Between [Forms]![Single Day Off Choices]![Start Date] And [Forms]![Single Day Off Choices]![End Date]
But it will not refill the form which works if using perameters
What have I missed
To display this info I have created a Modal Form that displays based on Parameters and that works fine.
I would rather that form open first and then select the dates that are being queried with two controls that select Start and End dates . These inputs work to and open a seperate query buy placing this in the Criteria of the date column of the query
Between [Forms]![Single Day Off Choices]![Start Date] And [Forms]![Single Day Off Choices]![End Date]
But it will not refill the form which works if using perameters
What have I missed