The user can click on the Search button to perform a search on any text field in the Customers table. I'd also like to have another button on the original form that when clicked will display a report with the search results.Īnswer: We've provided a download to demonstrate how you can set up search functionality.įirst, we've set up the form which displays the Customer records. Once the search has been performed, the original form will then display only those records that match the search criteria. On the popup form, the user can select (from a combo box) one of the field names contained on the original form and text to search on. Question: In Microsoft Access 2003/XP/2000/97, I'd like to have a button on a form that when clicked will open a popup form. ![]() This MSAccess tutorial explains how to create a form where you can search any text field in a table in Access 2003 (with screenshots). MS Access 2003: Create a form where you can search any text field in a table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |