Form Loading First Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that when I open automatically loads the first record. This
form is basically used to search for records but I do not want details of the
first record show up everytime the form is opened as it may confuse the user.

Is there anyway I can open the form with blank fields? Thanks.
ck
 
Use the Load event of the form to jump to the new record:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If
End Sub
 
Thanks, Allen. BTW, I love the audit trail code you did which worked really
great for me! Thanks a million for that piece of code.
ck
 
I tried this in my form that is for editing existing records only. I got
error 2046, Command RecordsGoToNew is not available at this time. What did I
do wrong?
 
Back
Top