Code working in 2K3, but not 2K7

N

NEWER USER

I have a form with one unbound combo box. The On Open Event is set as follows:

Private Sub Form_Open(Cancel As Integer)
Me.Text0.SetFocus
Me.Text0.Dropdown
End Sub

Works eveytime in Access 2K3 , but in 2K7 the form opens and the cursor is
blinking in the combo box. Any idea on why the combo box will not drop down
and display records? I have tried changing Overlapping Windows and Tabbed
Documents settings, but no difference. If I remove the code entirely, the
form opens and the combo box has the focus because it is the only object
available. Any help appreciated.
 
A

Arvin Meyer [MVP]

Try moveing your app to a Trusted Location. Look for "Trusted Location" in
the help files tor a description of how to build and place them.
 
N

NEWER USER

I set up a Trusted Folder where the database resides, yet it made no
difference on the dropdown field.
 
M

Maurice

It seems like a minor bug because it is actually dropping down but
immediately after that it's closing again. I tested it and can reproduce this
beaviour (also in A2010 btw)
 
M

Mike Painter

I get the same lack of results in a known trusted location, just a blinking
cursor.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top