Forum Discussion
Link Master and Child
=[Forms]![frmFXTracker].[frmFXParent].[Form].[txtIDFXParent]
seems close, but I think, in the control source property of the hidden form, though, it should probably be:
=[frmFXParent].[Form]![txtIDFXParent]
Hi George,
I think I understand conceptually. How do I set the value in the hidden field? I thought maybe by =[Forms]![frmFXTracker].[frmFXParent].[Form].[txtIDFXParent] (or something like that) but I dont think that is the solution. I need to set that hidden field to the value that is found in frmFXParent.txtIDFXParent.
Maybe using the On Current Event of the unbound form?
I tried it but doesnt work. Get an error of "invalid reference to the parent property":
Private Sub Form_Current()
Me.Parent.txtIDLink = Me.Parent.txtIDFXParent
End Sub
Me.Parent.txtIDLink = the hidden field
thank you for the help!
=[Forms]![frmFXTracker].[frmFXParent].[Form].[txtIDFXParent]
seems close, but I think, in the control source property of the hidden form, though, it should probably be:
=[frmFXParent].[Form]![txtIDFXParent]
- Perfect! thank you very much. It works great!
- Congratulations on solving the problem.