Help

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

When I select a Company name from a drop down menu (I
think produced with the lookup function and a seperate
table) my database WILL automatically display the
corresponding file number automatically in another
field.
I wish to reproduce this within other fields and
different information but I can not figure out how this
has been set up. Can anybody help?
 
Assuming you have a combo box "cboEmployee" of employees with a row source
of:
SELECT EmpID, EmpLastName & ", " & EmpFirstName, EmpPhone
FROM tblEmployees;
You have a text box on your form that you want to display the phone number.
Set the control source of the text box to
=cboEmployee.Column(2)
 
Back
Top