Open form to new record

[NWGal]

I have an unbound form with buttons on it for performing different operation. I have an unbound combo box and a button that opens my main contact form to the record matching the choice in the combo box. Works great. Now I want a "new record" button that opens the same contact form, but to a new (blank) record.
I need the vba code for the onclick event of this command button.
Thanks

[HansV]

Try this:

Code: Select all

Private Sub cmdNewRecord_Click()
    DoCmd.OpenForm FormName:="frmContacts", DataMode:=acFormAdd
End Sub

where frmContacts is the form to open.

[NWGal]

Try this:

Code: Select all

Private Sub cmdNewRecord_Click()
    DoCmd.OpenForm FormName:="frmContacts", DataMode:=acFormAdd
End Sub

where frmContacts is the form to open.

Yup! That did the trick. Thanks