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.