M
magicdds-
I want to set up the following nested subforms:
Main - has a field "OrderID"
subform1 - has a textbox "Name1" & Field "orderID" & "OrderID1"
subform2 - has a textbox "Name2" & Field "OrderID1" & "OrderID2"
subform3 - has a textbox "Name3" & Field "OrderID2"
Subform1 is linked Child & Parent with "OrderID"
To reference "Name1" I do the following:
X = Forms!Main!Subform1.Form!Name1
or
Forms!Main!Subform1.Form!Name1.Visible = true
My Questions are?
1) What do I put in the Link Parent and Link Child property for subform2 and
subform3?
2) How do I write code to reference Name2 (on subform2) and how do I
reference Name3 (on subform3) like I did above to reference Name1 (on
subform1)?
I appreciate any help with this.
Thanks,
Mark
Main - has a field "OrderID"
subform1 - has a textbox "Name1" & Field "orderID" & "OrderID1"
subform2 - has a textbox "Name2" & Field "OrderID1" & "OrderID2"
subform3 - has a textbox "Name3" & Field "OrderID2"
Subform1 is linked Child & Parent with "OrderID"
To reference "Name1" I do the following:
X = Forms!Main!Subform1.Form!Name1
or
Forms!Main!Subform1.Form!Name1.Visible = true
My Questions are?
1) What do I put in the Link Parent and Link Child property for subform2 and
subform3?
2) How do I write code to reference Name2 (on subform2) and how do I
reference Name3 (on subform3) like I did above to reference Name1 (on
subform1)?
I appreciate any help with this.
Thanks,
Mark