records not loading into form

[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.

 

[Gary Miller]

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