combined save and clear command button

S

susanhull

I'd appreciate help to create one command button that both saves the
data and clears the screen for the next record to be entered. Thanks
for your time.
 
A

Allen Browne

If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
 
S

susanhull

If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Show quoted text -
Click to expand...

Thank you, Allen. Your code worked beautifully. I appreciate your
expertise.
 

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
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Clear form Command 1
Clarification on 'Add New Record' Command Button 3
how do I clear all fields in a form? 5
Basic Comman Button Question 2
How to use multiple command button to copy user form data to multiple worksheet 0
How to clear the previous data 1

Top