How to save invisible column?

[longmatch]

I have a query returning two columns, one of them need to be show in combo box or other kind of control; other column does not show, but need to be saved in the backend database. Is there a way doing this? Thanks

Haijun

 

[MarkSweetland]

Use the MSFlexgrid. You can load the two columns, set the colWidth of the "hidden" column to 0, and the colwidth of the "visible" column to the width of the MsFlexgrid. Sort of looks like a Listbox..

Mark The law, in its majestic equality, forbids the rich, as well as the poor, to sleep under the bridges, to beg in the streets, and to steal bread.

Anatole France

 

[softwareguy]

If one column returned is an integer or long you can use the itemdata property of the combo box or list box.

cboResult.additem(rs!column1)
cboresult.itemdata(cboresult.newindex) = rs!column2

same deal for a listbox.

Less overhead than grid but not as pretty.