additem options

[fishman13]

Is there a way to use the additem method to be the control source for a combo box, but the additem list has two colums (one for display, the other for storage). For example, The combo box will have the list

Column1 Column2
1 Self
2 Spouse
3 Child
4 Other

The combo box will only show column2, but when the user selects an item the value in column 1 will be stored.

 

[cnguyen]

addlistitem(1,1,1)
addlistitem("Self",1,2)
addlistitem(2,2,1)
addlistitem("Spouse",2,2)
addlistitem(3,3,1)
addlistitem("Child",3,2)
addlistitem(4,4,1)
addlistitem("Other",4,2)

set the BoundColumn to 1 if you want to return 1
set the BoundColumn to 2 if you want to return "Self"