Searching For A Specific Record

[ShaunT]

Hi,

I have a database that I wish a user to enter specific information into in order to search and find a record.

The database contains Computer hardware info. I want users to enter the Etch number (Unique ID) of a machine and be shown all of the details of the machine.

How can I do this?

Many thanks for your help

Shaun

 

[Autoeng]

Create a form based on a query with all of the info that you want to show. Create a drop down combo box for the Etch # using the wizard and tell it you want to pull info from the query. The user will select the appropriate Etch # from the combo box and the info will display on the form. OR, if you want printed info create a parameter query which asks for the Etch # and send results to a report.

 

[ShaunT]

Thanks very much. That has solved it

Shaun