Is there a way to set up a form so that it applies a filter automatically when the form is opened so that a user only sees the filtered records without having to press the filter toggle or filter every time?
Is there a way to set up a form so that it applies a filter automatically when the form is opened so that a user only sees the filtered records without having to press the filter toggle or filter every time?
On the "Open" event use:
DoCmd.ApplyFilter , "Put your filter criteria here"