I'm a complete rookie in Access. I have a database with one table. The table has two fields, part number and tool number. The table is populated with data.
I need to develop a user interface that will allow the user to enter a part number or a tool number and click a button to list all the entries in the table that match the number entered by the user. See the attached image, this is what I want the form to look like. The table should populate with the matching entries.
I have no idea where to start. Do I create a query or a form or a report? Any tips to tutorials or any basic help would be appreciated. Thank you for helping me.
Access 2000