Save button

[Dukester0122]

I have a form called Remittance with the following fields:
RemittanceID, Customer, Address, State, Zip, Telephone

I've created a Save button which I want to save the data then clear the fields after. Here's my code:

Private Sub Save_Click()
On Error GoTo Err_Save_Click

DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNewRec

Exit_Save_Click:
Exit Sub

 

[PWise]

and what is the question

 

[Dukester0122]

I need help with the coding to clear the fields after saving...tks for asking!

 

[formerTexan]

Going to a new record should leave you with clear fields with the exception of insertions due to code or table level requirements.

Cheers,
Bill