Form Loading First Record

C

CK

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
 
A

Allen Browne

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
 
C

CK

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
 
H

HappyGirl

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?
 
Top