Data entry in form

[Tony M]

In order to make data entry easierin a form I want the
first and last name fields to be updated when an employee
number is entered. I have no difficulty doing this in
Excel via the H and Vlookup functions. Can you use a
lookup to do this in Access or is this achieved via code
only?

Thanks
TM

 

[Hugh O'Neill]

In order to make data entry easierin a form I want the
first and last name fields to be updated when an employee
number is entered. I have no difficulty doing this in
Excel via the H and Vlookup functions. Can you use a
lookup to do this in Access or is this achieved via code
only?

Thanks
TM

I would use a combo box to autocomplete the employee number and
retrieve the employee details. There's a wizard in the Toolbox that
sets this up for you.

hth

Hugh