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)
why do you need to Duplicate Same info from one table to another?
you can just write a Query that will link your subform table to your combo Table and Output
the 2 columns (from the Lookup table).
see this demo particularly Query1 which is the Recordsource of the Subform.