I am using MS Access 2003.
I have a couple of subforms on a form.
I have an "Assigned To" field in both subforms.
I want the 2nd subform "AssignedTo" field to default to the same value as the "AssignedTo" field of the first subform.
I am not sure how to do this?
Right now I have the default value of frmSubform2.cboWOAssignedToID:
Limit to List = Yes
Enabled = Yes
Locked = No
Both comboboxes in each subform are using the same query to pull data from.
Could someone point me in the right direction?
Thanks
I have a couple of subforms on a form.
I have an "Assigned To" field in both subforms.
I want the 2nd subform "AssignedTo" field to default to the same value as the "AssignedTo" field of the first subform.
I am not sure how to do this?
Right now I have the default value of frmSubform2.cboWOAssignedToID:
Code:
=[Forms]![frmWorkOrder]![frmSubform1].[Form]![cboWOAssignedToID]
Enabled = Yes
Locked = No
Both comboboxes in each subform are using the same query to pull data from.
Could someone point me in the right direction?
Thanks