C
Chuck Moore
I need some help with parameter queries associated with main form/subform.
My database includes an ER staff table and staff assignments table (positions
in the ER) that staff are assigned to each shift. I have a query that counts
the number of times that they are assigned to each position and have used it
to produce a report and also a look-up main form with subform. The main form
allows me to select a staff name and the subform then displays the counts of
all of their assignments. It is great. I have changed the query to a
parameter query that permits users to select a date range for both reports.
The problem is that I am prompted for a date range each time I select a new
staff name on the main form. Is there a way to set the parameter date range
once and then select a staff to view the results and then select another
staff on the main form without having to enter the parameter date range again?
My database includes an ER staff table and staff assignments table (positions
in the ER) that staff are assigned to each shift. I have a query that counts
the number of times that they are assigned to each position and have used it
to produce a report and also a look-up main form with subform. The main form
allows me to select a staff name and the subform then displays the counts of
all of their assignments. It is great. I have changed the query to a
parameter query that permits users to select a date range for both reports.
The problem is that I am prompted for a date range each time I select a new
staff name on the main form. Is there a way to set the parameter date range
once and then select a staff to view the results and then select another
staff on the main form without having to enter the parameter date range again?