Data entry in form

  • Thread starter Thread starter Tony M
  • Start date Start date
T

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
 
Tony said:
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
Click to expand...


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
 
Back
Top