Information automatically comes up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access and would have set up a database of employee id and their
names. I want to create a form that allows me to put the employee id in and
the employee name automaticallys comes up.

I would appreciate some step by step help in making this happen.

Thank you
 
First you need to set up a table with 2 fields:
EmployeeID
Employee Name
and enter all the possible employees into the table.
Employee ID must be a unique identifier that has no duplicates.
You may want to think about additional fields like first name, middle
initial, last name, address, sex etc while you are doing this.

Then you set up a form to display the data, how you do this depends on what
you want. Do you want to be able to just look at data, update the data or
what? The simplest way to set up a form is to use the wizard which will lead
you thru the process step by step.

You will need some education on Access which you can get from a book or from
the Access Help files.

-Dorian
 
Thank you. I have been reading up and have been very successful in my first
project.

All I want the form to do is for the user to put in the id number and the
name to come up. No editing etc. Once the name comes up then I the user
will continue on the rest of the form.

When I create the form using the wizard how do I proceed to get the form to
look for the name once the id is inputted?

Thank you so much for your help I appreciate it so much
Bryan
 
Back
Top