I have created 2 combo boxes in a form. the first combo box runs a query that
gives me the choices for the second combo box.
The query that I have have is as follows:

SELECT TblDepartment.Department, [Tbl Job Positions].[Job Position]
FROM TblDepartment INNER JOIN [Tbl Job Positions] ON
TblDepartment.[Department ID] = [Tbl Job Positions].[Department ID]
WHERE (((TblDepartment.Department)=[Forms]![Personnel MIV]![Department ID]));

My dilema is that, when I select a department for the first time after
opening the form, it works as advertised.  However, if I need to change the
department due to a transfer or what have you, the second combo box will not
give the appropriate Job Positions.
As a matter of info the tables that are driving the query have a one to many
relationship.
I need to have the Job Position combo box update every time I change the
selection on the department combo Box wihtout having to go in and out of the
form.

please help

Evert