Clearing contents of a form

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

Guest

This may be a basic question to ask, but it is frustrating me nonetheless!!

I have a form for users to enter data in, when each record is auto saved by
Access, I want the form to clear for the next record to be input, how can
this be done?
 
How are you saving the data? Typically this would be done by moving to a
new (blank) record.
When you save the data is the form remaining on that record?
 
The data is being saved automatically, though I do have a "save" icon that
runs the standard save record function when you add a button to a form.

And yes the form is staying on the current record
 
Thanks for responding Rick,
I am saving the record via a standard command button for "save record" on
record operations, I know that Access would save the record automatically but
the button is for the users.

And yes, the form remains showing the current record after the save button
is clicked.
 
Thanks for responding Rick,
I am saving the record via a standard command button for "save record"
on record operations, I know that Access would save the record
automatically but the button is for the users.

And yes, the form remains showing the current record after the save
button is clicked.
Click to expand...

Hi,

When I let the wizard create the "Save" button I get this code in the
click event:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

How about if you just add:

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec

....right after the original code. That should take you to a New Record.

HTH
 
Yes that has done it! Many thanks
--
Kevin


RuralGuy said:
Hi,

When I let the wizard create the "Save" button I get this code in the
click event:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

How about if you just add:

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec

....right after the original code. That should take you to a New Record.

HTH
Click to expand...
 
Back
Top