Log in

View Full Version : Query form



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

pieropingi
12-02-2011, 12:55 PM
i had to see the code, but peraphs i'm lucky:

have you a Me.Requery instruction somewhere?
I'd put that in StartDate_AfterUpdate and in EndDate_AfterUpdate, or in a button (for example Show_Click)