User interface to search for records in table

[proexpert]

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

[NoellaG]

Hi,

first I would look at the filter possibilities that Access offers by default. Maybe the solution to your problem is only a (right) mouse click away. Any basic tutorial (even the "for dummies" ) book will teach you these build-in features.

success
NG