New Record

[RayMilhon]

I have an Access 2010 Database. The primary form is going to be used for data entry. 90% of the time it will be to input a new record. What I'd like is when the form opens it opens to a New Record but the form needs to be Allow Edit. I haven't been able to make this work as yet any thoughts? Also the Form is based on a table not a query.

[June7]

What have you tried?

Could have code in the form Open event to move to new record row.

Or open it with code behind a button on another form:

DoCmd.OpenForm "formname", , , , acFormAdd

[RayMilhon]

The form is the startup form. I tried using a macro that fired when the form was opened to move to a new record row but that just generated errors. Your first option is what I had in mind but I cant find the method to move the form's recordset to a new record. I know I did this before but that was Access 2003 and a number of years ago. Don't remember how I did it and nothing I've tried works. Thanks for your help.

[June7]

Have you tried:

DoCmd.GoToRecord acDataForm, "formname", acNewRec

What have you tried?

[JoeM]

I just added the following line of code to the Form_Load event, and it seems to work well. It opens to a new record, but if I press the "back" record selector button to View/Edit existing records, I do not get any errors.

Private Sub Form_Load()
    DoCmd.GoToRecord , , acNewRec
End Sub

[RayMilhon]

Thanks I'll try that.

[RayMilhon]

worked like a charm