View/Update Form

[rhernand]

I have an Employee table and sometimes needs to be updated if an employee
moves to another department. I wrote a query that will select all of the employee's data. I want to use a View/Update Form that will display the employee's data, Department, Division, Cost Center, etc. However, each of the fields on the Form are Combo Boxes. In case the Department needs to be changed, the user chooses from the list.

My problem is that the data in the table from the query does not show up in the Combo Boxes. If I replace the Combo Box with a Text Box, the data is displayed. However, the user will need to type out all the new data, Department, Division, Cost Center, etc.

How can I remedy this?

 

[Uncle Gizmo]

>>> does not show up in the Combo Boxes <<<<

what is the record source of your combo box?
What is the column count, yet
indeed what are all of the properties of your combo box?

 

[rhernand]

Each combo box record source is a table, Dept table, Div table, etc. The column count is two; DeptID, Deptname.