Clear a data entry form

[Oyster]

My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?

 

[ghudson]

You need to create an Add new record button and use this command...

DoCmd.RunCommand acCmdRecordsGoToNew

 

[Oyster]

Isn't there a way to make it automatically do that once the Save button is pressed?

Thanks!!!

 

[ghudson]

You can do it by combining the two commands. My instinct is to advise that you do not do that for it could confuse the user.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdRecordsGoToNew

 

[Oyster]

I tried adding a "Add Record" button to my form with the code:
DoCmd.RunCommand acCmdRecordsGoToNew behind it. Now the "form" thinks I'm trying to add duplicate records when I press the "Add Record" button.

Thanks!!!