Combo Box does not drop down in Access 2007

[Song Su]

I made following code in Access 2003 and it works in 2003
However, when I use Access 2007 to open my 2003 mde, it does not drop down.
Use has to click arrow to drop down. How to fix it so it works on both 2003
and 2007? Thanks.

Private Sub cboName_GotFocus()
Me.cboName.Dropdown
End Sub

 

[Guest]

I cannot replicate this. When I try your code in 2007 it works. It doesn't
work when the form opens and your combo is the first field which gets focus.
F4 is an alternative keypress which the users can use. So you could set the
focus to antoher field when opnening the form.

hth

 

[Song Su]

It IS the first and only field of the form and no other field available. So,
it is working in 2003 but not 2007 when it is first field.
Users don't know the extra step of F4 or Alt+DownArrow. Microsoft made it
incompatible? Is there any way to force it drop down in 2003 code so it will
drop down in 2007?

 

[missinglinq via AccessMonster.com]

Place a textbox on your form, near the bottom left hand corner of the form
Goto View o the menu bar
Click on Tab Order
Make your new textbox the first control to gain focus.
Go back to your new textbox and shrink it's size as far as possible

Now when the form opens the new "phantom" textbox will receive focus and when
the user moves to the combobox it should, according to Maurice's post, now
drop down.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com