Drop Down

[mad-q]

Is there any way in which I can get a drop down menu to automatically drop down as the user starts type?

Thanks
Iain

 

[Severin]

Not really without it getting to messy...

You could do it on the Enter event of the combobox:

Private Sub YourComboBox_Enter()
Me.YourComboBox.Dropdown
End Sub

There is a download with free dropdown box examples here..

http://www.databasemakers.com/

 

[mad-q]

Actually what you said of Me.YourComboBox.Dropdown worked perfectly. When someone starts to type it auto drops down.

Many Thanks
Iain

Also the website you recommended is really good.