records not loading into form

  • Thread starter Thread starter j_70
  • Start date Start date
J

j_70

I have the following code that loads a splash screen and
then after the user logs in, opens a data entry form.

Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 3000
End Sub

Private Sub Form_Timer()
On Error GoTo Err_Hand
DoCmd.OpenForm "PROD", , , , acNormal
DoCmd.Close acForm, "Startup"
Exit Sub
Err_Hand:
Application.Quit acPrompt
End Sub

For some reason, the records in the database are not
loaded/viewable in the form. Also, the fields are not
search-able (I imagine since there are no records loaded).
If I open the form directly (bypassing the splash screen)
the records are loaded. I looked at the arguments passed
to the OpenForm method but didn't see one that would tell
it to load all the records. TIA.
 
Try just using....

DoCmd.OpenForm "PROD"

....and see if that makes a difference. Your 'acNormal' is in the wrong place
and that could be causing a problem.

Gary Miller
 
Back
Top