Open a Form to New Record

[AMC31]

I have a command button on the main screen. I want it to open a form and automaticaly go to a new record. Presently it opens 1 of 15 and you have one more step of clicking "new record"

Any help available would be greatly appreciated. Thanks.

 

[Kevin_S]

Put this in the 'On Open' event of the form:

Docmd.GoToRecord,, acNewRec

HTH,
Kev

 

[Mile-O]

On the command button's click event, put

DoCmd.OpenForm "frmYourForm", acNormal, , , acFormAdd