Code working in 2K3, but not 2K7

  • Thread starter Thread starter NEWER USER
  • Start date Start date
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.
 
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.
 
I set up a Trusted Folder where the database resides, yet it made no
difference on the dropdown field.
 
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)
 
I get the same lack of results in a known trusted location, just a blinking
cursor.
 
Back
Top