I am trying to set the default value of one control on a form to the value of another control on the same form.
The form's data source is a query which links two tables (Employees & Status) together.
In the Employee table there is a field called "Function" and in the Status Table there are...
