Auto Populated Field

[Tmcgee923]

How do I have a field(s) populate automatically based on a selection made
from a previous field. For example, A user selects the employee ID in one
field then this selection automatically fills in the field for employee last
name and employee first name.

Thank you, in advance, for your help.

 

[Jeff Boyce]

First of all, it sounds like you are working directly in a table. If so,
STOP NOW!

Access tables store data, but don't give you many options for
validation/control. If your users are working directly in the table, you
are asking for them to treat the tables as if they were spreadsheets ... and
they AREN'T!

Use forms, which have rich event/procedure environments, to help your users
work with their data.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Duane Hookom]

Also, it sounds like you want to store the last and first names in multiple
records. You should only store the EmployeeID and then lookup the names. You
can join to the employee table to display the names.