Jul 25, 2001 #1 subform MIS Aug 2, 2007 1 GB I have two subforms on a form. I am trying to access subform 1 from subform 2, the code i used in subform 1 is Set frm = Forms!frm_subform2 This gives me an error message. Anyway to access subform 2 from subform 1?
I have two subforms on a form. I am trying to access subform 1 from subform 2, the code i used in subform 1 is Set frm = Forms!frm_subform2 This gives me an error message. Anyway to access subform 2 from subform 1?
Jul 25, 2001 1 #2 tlbroadbent MIS Mar 16, 2001 9,982 US Use the following syntax to refer to a control on a subform. Forms!frm_Main!frm_subform2.Form!CtrlName Or Me!frm_subform2.Form!CtrlName Terry Broadbent "The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin Upvote 0 Downvote
Use the following syntax to refer to a control on a subform. Forms!frm_Main!frm_subform2.Form!CtrlName Or Me!frm_subform2.Form!CtrlName Terry Broadbent "The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin