Combobox Bound Fields Property

[jriano]

can a combobox have 2 bound fields?

I use a combobox (with uses a query) to select from a list. The thing is that two fields are needed to make a record unique. I need to hold columns number 1 and 2. How can I do that? any suggestions? thank you

 

[dcx693]

A combo box can store only one value, and it can only have one bound column. Your situation can be solved by using 2 combo boxes. However, if you must have the selections in only one combo box, you can simulate having two bound columns. Have a hidden field on the form. Have some code in the After Update event of the combo box that writes the values of the 2nd column to the hidden field using code like:
Me.[hidden_field]=Me.combo_box.Column(1)

The hidden field can be a bound field that gets saved to the underlying query.

 

[jriano]

thank you, that was exactly what I was looking for!