How set default in combo box ?

[David]

I have a combo box populated by a query.
However I want the default value to come from another
table. How is this done?

I have:
Departments table
Engineer table containing default department for Engineer

The combo box needs to show all values from the
Departments table with the default value for the Engineer
being pre-filled in.

 

[Kelvin]

How do you know who the default engineer for a department will be?

Kelvin