Simple MS Access query

[B&W]

Hi, I have a access database with around 500 records. Now I want to be able to load it up and search one of the columns for certain records.

I dont want to make a query for every single record manually that would take forever.

I just want a simple box to come up where I enter in the information im looking for and then a table appears with the relevant record.

How would I go around doing this?

 

[RockLobster]

Create a new query and for the column you wish to base your search for in the criteria bit put in = [Type in a search item] when you run the query it will popup a box asking you to search for something type it in click ok and it should bring back the record you need.

 

[B&W]

thanks