If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Populated Field
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. |
#2
|
|||
|
|||
Auto Populated Field
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 "Tmcgee923" someoneyoucantsee.com wrote in message ... 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. |
#3
|
|||
|
|||
Auto Populated Field
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. -- Duane Hookom Microsoft Access MVP "Tmcgee923" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|