How to make combo box automatically drop down?

[Top Spin]

I created a data entry form with a combobox so I can select data from
linked fields in another table.

When I tab to that field, the combobox does not drop down unless I
press alt+downarrow. Is there some way to get it to automatically drop
down and slow the selection choices?

Thanks

--
Running MS Office 2K Pro
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)

 

[Tom]

Try

With Me!NameOfTheComboBox
.SetFocus
.DropDown
End With

Tom

 

[Van T. Dinh]

Use the ComboBox_GotFocus Event to run the statement:

Me.MyComboBox.DropDown