What are Access Lookup Columns good for?

[artlaugher]

I'm looking to add some VLOOKUP()-style functionality to an access form.

I want to be able to ask the user to enter an 'Employee Number' into the form then -based on their entry- populate an 'Employee Name' field. I need both bits of data to live in the record so they can eventually be mail-merged into a Word document.

Any hints as to the best way to solve this problem? Gracias in advance.

[JieJenn]

Lookup servers as drop down menu. I think what you are looking for is DLookup function in MS Access.

[alansidman]

I think that this is what you are looking to do and how to do it. You would create a combo box with your choices for your user to select from and then populate the other fields based upon this link.

http://www.baldyweb.com/Autofill.htm

Alan

[Richard Buttrey]

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

In addition it's in the wrong forum. I'll move it for you on this occasion but please remember for the future.