First, we've set up a form where the user can enter a search string. In the example below, we've entered "store" as the value to search for in the CompanyName field.
When the Search button is pressed, the following message box will appear:
Your form will then display the search results as follows:
Please note that this method of searching is achieved by using a form and a subform.
Pay close attention to how the RecordSource is set on the form called frmCustomers_sub. The RecordSource on this form is updated using VBA code and not in the Properties window.
We've also included a "Show all customers" button in case you wish to view all customer records.
