Forum Discussion
Solved
Forms 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 ...
12Jasper34 If your combobox is in Form1 then you need to mention Form1 name and Subform1 name. If combobox is in subform1 then just use "Me" like
Me.ControlB=Me.ComboBox.Column(1) Me.ControlC=Me.ComboBox.Column(2)
12Jasper34 If your combobox is in Form1 then you need to mention Form1 name and Subform1 name. If combobox is in subform1 then just use "Me" like
Me.ControlB=Me.ComboBox.Column(1)
Me.ControlC=Me.ComboBox.Column(2)- Thank you Harun24HR. The Combo Box is on subform1 and your code above does the job.
Does the job. I have been retired for two years from a job where I used MS Access extensively, funny how much I have forgotten in those two years.
John Schreiber
