Click on "Save" button twice to save record

Posted on 2012-09-05
Last Modified: 2012-09-11
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?
Question by:kris_sk2012
    LVL 61

    Accepted Solution

    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:

    LVL 47

    Assisted Solution

    by:Dale Fye (Access MVP)

    me.Refresh, to save a record?


    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.
    LVL 61

    Expert Comment

    Refresh is another way to force-save edits made in a form to the underlying recordsource.
    LVL 61

    Expert Comment


    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.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now