I would like to edit employee details using combo box to select the employee.

[krishnan Kumar]

In my form, i have three fields, 1)employee name, 2) Active, 3)department.

I bound the form with employee table.
I want to use combobox to select the employee to edit their department names in the same form.
when i select the employee, i can assign the value to employee text box but the employees department doesnot change. It seems like the form donot get the department information for the employee. how do i refresh/goto the record in the form based on my selection?

Thanks,
Kumar

[RuralGuy]

Let the ComboBox wizard create another unbound cbo to look up the record. Select option #3 from the wizard.