office 365 ms access 2016
1 TopicForms and Subforms syntax
I have a Form with a sub form. For ease of this explanation, I will call the form (Form1) and the subform (Subform1) On Subform1 I have 3 field controls, A, B, C I will use a Combo Box tied to a query to select Control A, B, and C data. The Combo box is bound to control A. This works. I am looking for the Combo Box event syntax on the After Update event to push the Control B and C data to their respective controls. Possible Code: So, the Combo Box After Update event might look something like Control B = Combo Box.Column(1) and Control C =Combo Box.Column(2). It has been a while since I have worked with syntax when referring to an SubForm control? Do I need to include the Form1 name and the Subform1 name in the Combo box After Update event? Refer to Possible Code above? How would this be written? Please show appropriate syntax. Thanks, John Schreiber email address removed for privacy reasonsSolved1.6KViews0likes4Comments