How to clear the content of controls in the form

[usermj]

I designed a Data Entry interface. I wish the system can automatically clear all the values of controls in the form after users click the 'save' button.

Is there any good solution instead of manually setting each control's value to null?

I tried Undo method, but it didn't work on either control (textbox) or form itself.


Many Thanks

 

[ghudson]

You could set the current record to a new record.

DoCmd.RunCommand acCmdRecordsGoToNew

 

[nblade]

Clearing data on parent form & subform

I've searched the forums and found that DoCmd.RunCommand acCmdRecordsGoToNew does a good job of saving the data and clearing the current form. My problem is that the button for this lies in a subform and I want to clear the data in the subform and the parent form.

If this isn't possible, is there a way to set the tab order from an object in a subform to an object in the parent form?

Thanks!