What do I change

[Bob]

I am getting a error on second line , is it that I have to change Me.Name to
something?
Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub




Thanks in advance.........Bob Vance

 

[Randy Balbuena]

I am getting a error on second line , is it that I have to change Me.Name
to something?
Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub
~ ~
Thanks in advance.........Bob Vance

Bob,

If you want to have a form exclusively dedicated for new records, you just
have to set the DataEntry property of the form to True. This will only allow
the form for new records to be added, which is what I guess your are trying
to accomplish. Either way the correct parameter is acNewRec and not
acNewRecord.

Does that help?

 

[Jeff Boyce]

Bob

Another approach might be:

DoCmd.RunCommand acCmdRecordsGoToNew

 

[Bob]

Thanks randy changed the script and it worked?

Bob,

If you want to have a form exclusively dedicated for new records, you just
have to set the DataEntry property of the form to True. This will only
allow the form for new records to be added, which is what I guess your are
trying to accomplish. Either way the correct parameter is acNewRec and not
acNewRecord.

Does that help?