Multiple bound columns?

[MW]

I have a combo box that displays four fields of information and want those fields to fill in four fields on another table. Is it possible to bind mutliple columns to multiple fields in one combo box? If not, how can I do that without having to do four separate combo boxes, one for each field?

Thanks!

 

[chrismcbride]

Probably the simplest way to do this would be to bind the combo box to one of the table fields that you want to update. Then add three invisible controls on your form that are bound to the other table fields you want to update. In the AfterUpdate of the combo box add...
me.text1 = me.cboWhatever.column(1)
me.text2 = me.cboWhatever.Column(2)...
Rememeber that the first column in a combo box (which is usually designated as the Bound Column) can be referenced as Me.cboWhatever or me.cboWhatever.Column(0)
HTH
Chris