Seperate Value & Code for Combo box

[shangrilla]

Hi:

Table with 2 columns

KeyValue DisplayValue
1 Tables
2 Chairs
.
.

Can I have a combo box in which the display value is 'Tables, Chairs...', but the code to look up these values is '1,2...'?

 

[Mike Gagnon]

If you set the BoundColumn to 1, the Value property of the combobox will return the first field value, if you set the BoundColumn to 2, the Value property will return the second field value.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[mejiaks]

sure you can, try this

put this code in the interactivechange of your combo box

MESSAGEBOX(ALLTRIM(STR(This.ListIndex)))

 

[BPeisch]

One thing you have to understand about combos, the textbox portion will display whatever is in the first column of your RowSource, so if you want the DisplayValue shown, you need the RowSource to be RowSource, KeyValue. You'll want to set the combo's BoundTo to .T. if the bound column (Column2) is numeric. Then you can set the ControlSource to be the foreign key field in the table you want to store the returned value in.


-BP (Barbara Peisch)

http://www.peisch.com