I am using a combo box on my main form so that the user can select a unit. The AfterUpdate property of the combo box creates a recordset clone and the results are displayed in a subform on the main form. This part works great.
I would then like to have the user select a StartDate and an EndDate from two more combo boxes on the main form and have the previously displayed results further filtered by the StartDate and EndDate and displayed in the subform.
If I can clone the Recordset Clone I'm not sure how to write the code. Any suggestions?
Thanks.
I would then like to have the user select a StartDate and an EndDate from two more combo boxes on the main form and have the previously displayed results further filtered by the StartDate and EndDate and displayed in the subform.
If I can clone the Recordset Clone I'm not sure how to write the code. Any suggestions?
Thanks.
