Richard: I have a form the has two separate sub-forms embedded. I need a value from subform 1 to be entered into subform 2. Please see my picture. I figured if I add an "on click" to the specific BudgetID (from subform 1) to copy the value into the unbound text box and hide it), then I can use "Status Forms!frmContractBudgetwithIDSub!frmActualBillingEntry!BudgetID" to update the BudgetID field in sub form 2.
(I watched "Value Open Form" extended cut video but it did not get me there because this is a Form that has two subforms inside it.