Searching for Data

N

Noah

I saw a Lotus Approach application that I would like to
duplicate in Access. Basically all it looks like is a form
(with field discriptions and empty boxs) that lets the
user enter an employee number in a field. After they
press enter it searches a table and brings back data that
matches the employee number they entered. The user can
then edit the data that was returned.

It looks like a simple 'search' screen. I have looked in
Access for a way to do this in a form but I can't figure
it out.

Can anyone help?

Thanks
 
B

Bob

The same can be done in Access by creating your table(s)
for the data that you want to store. Depending on your
complexity you may only be creating a "Employee" table. A
form would be created to allow users to enterinformation
that will be stored in the Employee table...you can use a
wizard to create the form for you. Once the form is
created, open the form in design view and add a combo box
to the form header using the wizard. There's a selection
that you pick that asks what the combo box will be used
for. Tell it that you want it to look up values from a
table. When the user selects a name from the combo box,
the appropriate record will display on the form.
 
Top