I would like to attatch a find form to a cmd button that filters the main form. The filter will be based on the user inputting a start_date and stop_date in the form.
any suggestions
Thanks
In the Date field of the query that fills your new form, add the criteria:
Between[Enter start date] And [Enter end date]
This will force the user to input to dates which will limit the size of the recordset returned by the query