Learning MS Access - need help understanding how to link one field to another

[Sloopybonn]

I would like to design a form where when an employee's ID number is entered, the form would automatically display the employee's name. This name would be pulled from the same table that the ID is kept in.



Any help to understand how to link one text field to a comma box or another text field, and make it react upon data entry, would be appreciated.

[June7]

Use a multi-column combobox - RowSource like: SELECT EmpID, LastName & ", " & FirstName AS FullName FROM Employees;

Expression in textbox can reference combobox column by index, index begins with 0: =[cbxEmp].Column(1)