combined save and clear command button

  • Thread starter Thread starter susanhull
  • Start date Start date
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.
 
If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
 
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
Basic Comman Button Question 2
how do I clear all fields in a form? 5
How to use multiple command button to copy user form data to multiple worksheet 0
How to clear the previous data 1

Back
Top