Opening a new blank form rather than first record in the table

[sbrown18]

Hi guys



I have created an asset database but have a problem with one of the forms.
I have a form with the button 'New Asset' and when I click it opens a New Asset form so I can enter new asset details. The problem is that it opens the first record in the table rather than a brand new (empty) record which I require. Can anyone help.

The code I have on the 'New Asset button' is below

Private Sub Openad_Click()
On Error GoTo Openad_Click_Err
DoCmd.OpenForm "Asset Details", acNormal, acFormAdd
On Error Resume Next
DoCmd.Requery ""
DoCmd.GoToRecord , , acNewRec
Openad_Click_Exit:
Exit Sub
Openad_Click_Err:
MsgBox Error$
Resume Openad_Click_Exit
End Sub

[maximus]

Paste only this line to the onclick event of your button

DoCmd.OpenForm "Asset Details", acNormal, , , acFormAdd