Click on "Save" button twice to save record

For some reason my Access interface requires me to click on Save button in the form twice to save a record. Is it an issue with Access?
kris_sk2012Asked:
Who is Participating?
 
mbizupCommented:
What code or macro do you have behind the command button, and which event is that code in (as a sanity check, make sure it is not in the double-click event of your button)?

If you are using a bound form, the following should work in the Click event of your command button:

Me.Refresh
0
 
Dale FyeCommented:
@Miriam,

me.Refresh, to save a record?

@kris,

I usually use:

me.Dirty = False

To save the current record.  Where is your Save button?  Do you have navigation buttons on the form?  In addition to seeing the code or macro that is being executed when you click the save button, it might help to actually see the form, in design view.  Can you take a screen shot and post that as well.
0
 
mbizupCommented:
Refresh is another way to force-save edits made in a form to the underlying recordsource.

http://msdn.microsoft.com/en-us/library/office/aa221562(v=office.11).aspx
0
 
mbizupCommented:
kris_sk2012,

Also, if the form is unbound (ie: its recordsource property is blank), then we'd need a bit more info.  It would clarify this question a good deal if you could post a sample copy of the database with any sensitive data masked or removed.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Also note that Records in Access are saved automatically, so normally there is no need for an explicit "save" button"

Obviously, you may need to save the record via code for some other reason, but as mbizup requested, we may need to know a bit more about this system.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.