Access 2007 closes my dropdown

I don't have another suggestion for you. Let me contact a person with more
experience with ACCESS 2007 and see if he has suggestions.

--

Ken Snell
MS ACCESS MVP


"Song Su" wrote in message
...
I created a blank testing db1 using Access 2003 with 1 table and 1 form
there is only 1 cbobox on that form.
On got focus event, I setup dropdown. Testing on 2003 no problem.

I use Access 2007 open it. It drops down and close immediately.

"Ken Snell (MVP)" wrote in message
...
This code does not set the TimerInterval property, so the hidden form
must have a value in that property if you look at the form in design
view. I remain convinced that the running of the form's Timer event is
what is causing the dropdown to go away. What do you see on your form if
you do not run the hidden form's code (change the Timer Interval value to
0 in design view of the hidden form to test this)?

Hi Song,

There's definitely a bug here. I can repro this on Access 2007 SP1.

I can even tell that the combo box did indeed drop down because I still see the "Edit Items" button
on the form where it would be when the combo box drops down.

I'll open a bug in our system. Thanks for bringing this to our attention.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Song Su" wrote in message:
...

I created a blank testing db1 using Access 2003 with 1 table and 1 form
there is only 1 cbobox on that form.
On got focus event, I setup dropdown. Testing on 2003 no problem.

I use Access 2007 open it. It drops down and close immediately.

Thank you, Jeff. I also tried to start a fresh Access 2007 database, make 1
table and 1 form. put single combo box on that form. On GotFocus event,
me.combox0.dropdown. When I open that form, the cbobox drop down and close
immidately.

"Jeff Conrad [MSFT]" wrote in message
...
Hi Song,

There's definitely a bug here. I can repro this on Access 2007 SP1.

I can even tell that the combo box did indeed drop down because I still
see the "Edit Items" button on the form where it would be when the combo
box drops down.

I'll open a bug in our system. Thanks for bringing this to our attention.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Song Su" wrote in message:
...

I created a blank testing db1 using Access 2003 with 1 table and 1 form
there is only 1 cbobox on that form.
On got focus event, I setup dropdown. Testing on 2003 no problem.

I use Access 2007 open it. It drops down and close immediately.