In my Microsoft Access database, I have a search form with the following specifications (also see attached snapshot):
At the top - I have two search fields (last name and first name). If user enters data in both, will search for both fields; otherwise, it will only search for the field that data is entered.
In the middle - I have a listbox, which will display matching search results - showing last name, first name and birthdate (id is hidden) after the Search button is clicked.
In the last section, I have 4 command buttons - search , view selection, add client, exit. When user makes a selection and click View Selection, it will take the user to a different form showing detail information. Thanks!