Updating field on From

[Guest]

I have a EmpID dropdown field with a query that selects all the Employees ID,
depending on the selection of the EmpID , I want to fill the next field with
the Employee's name that matches the EmpID matching the previous selection.

Thank you.

 

[John Vinson]

I have a EmpID dropdown field with a query that selects all the Employees ID,
depending on the selection of the EmpID , I want to fill the next field with
the Employee's name that matches the EmpID matching the previous selection.

Thank you.

If you just want to *display* the name, include the name in the Combo
Box's Row Source query and put a textbox on the form with a control
source

=cboEmpID.Column(n)

where cboEmpID is the name of the combo box, and (n) is the zero based
column in the row source query.

If you want to store the employee's name redundantly in another
table... well, you almost certainly DO NOT want to store the
employee's name redundantly. This form's table should not have the
name stored.

John W. Vinson[MVP]