Display empty form after update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know I'm overlooking the straight-forward method (as usual)...

I have a data-entry form bound to a table. Some table fields are derived
from some unbound form controls. The form has a command button with code
that adds a record, populates the record with bound and derived data, and
updates the record. I would like a blank form to appear, but how?!?

Each time I open the form and click the "Save" button, a record is
successfully added. I can abort and restart the form, and it will add a
record correctly. I just need to display a blank form.

I tried to set each control to "" after the update, but I received an error
on a control bound to a required field.

I know you all know an easy answer, but I think I've been taking dumb pills
:-) Thanks for your help!
 
Each time I open the form and click the "Save" button, a record is
successfully added. I can abort and restart the form, and it will add a
record correctly. I just need to display a blank form.

Add a line

DoCmd.GoToRecord acForm, Me.Name, acNewRecord


John W. Vinson[MVP]
 
Back
Top