How to use save button to open new form as well....

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

Hello Again!

How would I go about getting the save button on a form to not only
save the entry in the table, but also getting a new fresh record to
pop up once it has been saved? Currently we have an "add new record"
button to go along with save, delete, and exit... but is there a way
to have the save button not only save the new record entered, but also
have it bring up a new fresh record as well? Many thanks, you've all
been extremely helpful and patient. Keep up the great work!

Kevin
 
Try using the following after your "Save" command in the module behind
the "Save" button:

DoCmd.GoToRecord , , acNewRec

Matt
 
Thanks Matt...that works just as written. I appreciate your
assistance!

Kevin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
DMax on existing record to increment serialized # fails 1
Pop-up form that creates record that links 1:1 to main form 0
New record button 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Clarification on 'Add New Record' Command Button 3
Macro doesn't work first time form is opened. 2
Data Entry Only 7

Back
Top