Filter Access Form to Show One or All Records ~ DataPig
This video demonstrates a technique to filter records on a form. It uses a combobox whose RowSource has the unique companyId and companyName. Also the details of the combobox properties are described. With little code in the combobox after update event, a specific record is filtered and displayed. A button is added to the form and is used to clear the existing filter. By clearing the filter, all records are again available for filtering/selecting.
Here is the video that Mike referred to:
Multi-Column Combobox in Access ~ DataPig (6m28)
• Multi-Column Combobox in Access ~ DataPig
Here is another video for setting up a combobox:
Combo Box properties in Microsoft Access (11m25)
• Combo Box properties in Microsoft Access
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.