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

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
 
M

Matt

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

DoCmd.GoToRecord , , acNewRec

Matt
 
B

Bayou BoB

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

Kevin
 

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

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Copy previous record into form field 0
Synchronization problems while moving folders to new email 1
Merging from an Excel file with graphics 1
How do I clear a form? 0
New record button 1
Macro doesn't work first time form is opened. 2
Make "File in use" message appear when 2 people open the a shared document in the same time 3

Top