Question Looking up information and fill in form

[AliBabba]

Hi everyone,

I am a beginner when it comes to Access and just started to play around with a small database.

I have a form, "Update Employee Information" that allows me to navigate through records and change data like name, adress, etc. I would like to know how to create list (or autofill) so that it won't take long before finding an employee.

For example: I have a Employee ID and would like to search on that so the form can fill in the rest of my information. I have thought of two methods that I like:

(1) Click on a list "Lookup Employee", select ID and then the form will fill in the rest

(2) Without clicking a link, typing in the ID in the form and the rest of the data gets filled in.

How do I accomplish this? I've seen some video tutorials but I'm not quite sure how to make it.

Thanks in advance!

 

[nanscombe]

You could try placing a ListBox on your form and using the Listbox wizard to do the work for you.

When the wizard appears choose the "Find a record on my form ..." option.
Click Next

Choose the field you want to use as a look up then any other name fields. Click Next

Choose whether you want to hide the key column (which is used to look up the record). Click Next

Give it a name and click Finish.

 

[AliBabba]

Sorry for the late reply. The wizard you advised worked very good. Thank you

 

[nanscombe]

That's all right. I'm glad it helped.

 

[AliBabba]

Just one last question:

I have a form with a Listbox at the moment that automatic fills my Guests (Full name). But what work-around do you recommend when there are two names that are the same.

For example: I have two guests with the name 'Michael Jackson'. The list automatically grabs the record of the first 'Michael Jackson' when typing his name.

Thanks in advance .