Dropbox

[roger]

using a combo box I need to access the row in the array.
we can use the column now ie: combo993.column(3)
I need a way to get the row ie: combo993.column(3,1), the
(1) is the selected row by the user using the cursor to
move through the array and selecting an item.
can anyone help?
thanks

 

[Van T. Dinh]

If I understand correctly, you want to get the value of a particular column
while the user is still navigating the drop-down list?

In this case, I don't know the answer but then I never had any need for this
after years of using / programming Access. Looking through the list of
Events associated with ComboBox, I cannot see any Event you can use in this
case.

Is there any particular reason that you cannot wait until the AfterUpdate
Event?

 

[Armando Ruiz]

You are better off using a list box and use the
After_Update() event, from there you can access any
column that you want.