Combo Box question...probably obvious....

[linwoodrc]

Hopefully an easy one...(although, that would make me look pretty silly)

I have a combo box (getting its info from a table) for our customers. It works nicely. Here's what I want it to do....

When I start to type in the field, it scrolls as it should. BUT, I would like the combo box to "auto drop and scroll" when I start to type in the field, rather than having to click on the little arrow to make it drop down. We have several customers with the same Company name, but different cities. This would allow me to save some keystrokes, as well as speed up selections by being able to page up/down in a general area...

Is there a default setting that would do this??

Thanks for your help in advance....

Dave

 

[pono1]

Dave,

In the combo's change event, call the combo's dropdown method:

Private Sub ComboBoxName_Change()
      Me.ComboBoxName.Dropdown
End Sub

Regards,
Tim

 

[linwoodrc]

Tim,

YOU are my new hero!!! Thanks so much for your expertise!!! This will greatly speed up our system..... I am changing every combo box field now.

I have always had great response on this board....KUDOS to all!!!


Dave