Updating field on From

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Back
Top