Selecting Next Combo Box Item

[Guest]

Hi,

I used to use
Combobox.ListIndex = Combobox.ListIndex + 1
to move to the next item in my combo box. It doesn't work in Access 2002 any
more. My combo box is based off of a select Query and the data from the combo
box is bound on column 1. I have a list of clients in the combo box and when
the user double-clicks on the combo box it moves down to the next broker in
the combo box list. What can be used to do this now? Any advice please....
Thank you in advance.

 

[Guest]

Hi,

You can use

Combobox = Combobox.Column(0, Combobox.ListIndex + 1)

assuming that the combo is bound to column 1 and the next in the list exists

HTH

 

[Guest]

You so totally rock! (my son watches Nemo a lot) That worked and much nicer
than my earlier attempts - FAST!
I've never used the extra switches after .column(0) so I will have to read
up on those to understand what it can be used for. For the time being, thank
you very much!

Niki

 

[Guest]

Niki,

Join th club - my soin watches it too - I know virtually the whole script by
heart.

One more thing - if the question is answered it would help others if you
mark it as answered.

Happy programming!

 

[Ken Snell [MVP]]

Don't know if this would interest you, but I have a sample database where
you can use spin arrows to move the combo box up and down its list without
opening the dropdown list. See
http://www.cadellsoftware.org/SampleDBs.htm#Cbospin