G
Guest
how to save the combobox contents in a form
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
To save the contents of the combo column you need to assign the values from
this coumn to the form field. So on the after update event of the combo you
need to insert the code
Me.Field1=Me.ComboName.Column(0) ' The column number start with 0
Me.Field2=Me.ComboName.Column(1)
Me.Field3=Me.ComboName.Column(2)
Me.Field4=Me.ComboName.Column(3)
Me.Field5=Me.ComboName.Column(4)
etc
this coumn to the form field. So on the after update event of the combo you
need to insert the code
Me.Field1=Me.ComboName.Column(0) ' The column number start with 0
Me.Field2=Me.ComboName.Column(1)
Me.Field3=Me.ComboName.Column(2)
Me.Field4=Me.ComboName.Column(3)
Me.Field5=Me.ComboName.Column(4)
etc