Transferring list items between combo/list boxes

[John Hawker]

I have a multi-select combo populated by a multi field query. I want to
transfer 2 fields (key and name) from selected items to a list box. I can
transfer the key but cannot figure out have to copy the other field. I
looked at QueryDefs but didn't find anything on how to accomplish this. Any
ideas?

Thanks,
John

 

[Jim Burke in Novi]

As far as I know there's no such thing as a multi-select combo box, you can
only select one item at a time. If you mean you're selecting a value from a
combo box and want to reference multiple fields, you use the column property,
with column(0) being the first field, column(1) the second field, etc., e.g.
cboField.column(1) if you want to reference the second field. When you
reference a combo box without specifying a column, the default value is the
bound column, i.e. if the combo box's Bound Column property is set to 1, then
specifying cboField is the same as specifying cboField.column(0) - the 'bound
column' property is not zero-based, but the column property is.

 

[John Hawker]

My mistake, I was thinking of something else as I wrote that. But I did need
the assist on the columns. I got it working, thank you.

John