Forum Discussion
Forms and Subforms syntax
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)
arnel_gp and Harun24HR. I am not duplicating information. Form1 contains data about a show (Dog Show). Subform1 will contain information for different Dogs for that selected show. The Comb Box is on the Supform1 and provides a list of Dogs that could be in the show. Control A, B, and C on subform1 will be loaded with the Dogs information from the Combo Box. So, the Combo provides a list of eligible Dog information that will be stored in a table linked to the Show.
I need the syntax to load the selected information from the Combo box columns (3) into fields A, B, and C on subform1. The A information is easy because it is the Bound control for the Combo Box. I need the syntax for Combo Box Columns 1 and 2 to be loaded into B and C from the After Update event of the Combo Box. Again, the Combo Box is on Subform1. I hope this helps.
John Schreiber
email address removed for privacy reasons