bind multiple columns?cboBox

[pungentSapling]

is it possible to bind multiple columns in a combo box?
if so how?
thanks
p

 

[bradcccs]

On the After Update event of the combobox, use something of the like:

me.2ndFieldIwantbound = me.combobox.column(2)


The .column(#) refers to the number of the column.

Note that the column count starts at 0 though.

ie:
0 = First Column
1 = Second Column etc.

Brad.

**
An aside:
Remember to ask yourself: "Do I need to store that extra column, or can I look it up later from the stored pk?"

If you need to store it, then the above method will do the job.
**