Auto populate a form control box based on different control box en

C

CWC

I have a table named “tblEmployeeAssignment†which has two fields named
“Employee†and “Assignmentâ€.

I have a second table named “tblDisabilityUsed†which has several fields,
two of which are also named “Employee†and “Assignmentâ€.

I have a form named “frmDisabilityUsed†with its data source linked to
“tblDisabilityUsedâ€

I use the form “frmDisabilityUsed†to add new records to “tblDisabilityUsedâ€.

After selecting the employee name in the “Employee†control box of the form,
I want the “Assignment†control box to automatically populate with the
correct text based upon “tblEmployeeAssignmentâ€.

For example, when I enter “Doe, Jane†in the “Employee†control box of the
form, I want the “Assignment†control box to automatically populate with
“Shift†because in the “tblEmployeeAssignment†where the “Employee†field
equals “Doe, Janeâ€, the “Assignment†field equals “Shiftâ€.

I would like to happen upon selecting the name in the “Employee†control
box without having to select the “Assignment†control box.

Thanks in advance.

CWC
 
Top