B Batocanin New member Local time Today, 07:51 Joined May 30, 2022 Messages 7 Oct 20, 2022 #1 in Form "Main" there are two subforms "SubF1" and "SubF2" How to set velue from "SubF1.ID" to "SubF2.ID"
in Form "Main" there are two subforms "SubF1" and "SubF2" How to set velue from "SubF1.ID" to "SubF2.ID"
June7 AWF VIP Local time Yesterday, 21:51 Joined Mar 9, 2014 Messages 6,061 Oct 20, 2022 #2 Why would you need to do that? How are these datasets related? Are these ID fields both autonumber? If you want to provide db for analysis, follow instructions at bottom of my post. Last edited: Oct 21, 2022
Why would you need to do that? How are these datasets related? Are these ID fields both autonumber? If you want to provide db for analysis, follow instructions at bottom of my post.
B Batocanin New member Local time Today, 07:51 Joined May 30, 2022 Messages 7 Oct 20, 2022 #3 No I take ID as example, SubF1.A1 has a number which schuld be copied in SubF2.AA1 Tables from this two subforms are not related.
No I take ID as example, SubF1.A1 has a number which schuld be copied in SubF2.AA1 Tables from this two subforms are not related.
Gasman Enthusiastic Amateur Local time Today, 06:51 Joined Sep 21, 2011 Messages 17,209 Oct 20, 2022 #4 I believe the standard method is to have a hidden control on the main, which references subform1 control. Then subform2 control references that hidden main form control?
I believe the standard method is to have a hidden control on the main, which references subform1 control. Then subform2 control references that hidden main form control?
C CJ_London Super Moderator Staff member Local time Today, 06:51 Joined Feb 19, 2013 Messages 17,616 Oct 20, 2022 #5 Or in subF1 parent.subF2.form.AA1=A1
