[RESOLVED] Using combos

[Strider]

i want to load data into to a combobox in VBA, however i dont know how to get it like in vb.net where you can specify the value member and the display member.

As i want to load my table ie: mytable(col1,col2) into the combobox and show the values of col2 in the combobox but when the user selects an item i need to get the col1 value of the selected item

[RobDog888]

Which Office program are you using? Access or Excel?

Is it interacting with vb.net?

[Strider]

access 2002 no its not interacting with vb.net

was just trying to get it like the way it is done in .net where you can get the selectedvalue


Also how can i display both the fields in the combo when an item from the list is selected..... i can get it to show the fields when the user does the drop down but when they select an item it just shows the one field

[ninajr]

You can code in your program :

combobox.boundcolumns = "col1"
combobox.listfield = "col2"