Access 2007 not saving on form design viewer

Posted on 2011-10-12
Last Modified: 2012-05-12

We are having an issue with an Access 2007 database, on the design view of a form/subform (see image 1) and then going to Properties on that design view, we go to the "..." icon on the "record origin" or record source (I don't have the english version, see image 2) we go to a panel where we have the table and we choose records to be shown (see image 3).

We can add records by double clicking on them and we can see in the lower panel the field is added, but when we save, the change is not made. Why can this happen?

the change can be made via query, but it's not the best way to work and it should work both ways.
 design view in form/subform record source or origin wher the error happens
Question by:AxlTrauts

    Author Comment

    I found what seems to be an answer:

    We used to first close the Properties windows and then close the Query Generator (the left window), or not closing the Properties windows at all.
    When we close the Properties window first before closing the Query Generator (or "Generador de Consultas" in spanish) it works.

    If you can confirm me this, i'd appreciate it :)
    LVL 61

    Accepted Solution

    I think you have a typo in your above comment - the problem you cite is exactly the same as the resolution you described.

    But in short, yes...

    Explained -

    You need to close the query buider first, since it defines the RecordSource property.  When you change the query you will be prompted with a "Save? Yes/No" type of message, which alerts you to the fact that changing the query will change the form or report's Recordsource property.  

    If you close the property sheet first, there is no 'connection' between the recordsource property and the query you are modifying in the builder.  So when you close the query builder, there is no longer any specific property for that query to be applied to (any changes are effectively thrown away)

    Author Closing Comment

    Thank you very much. It seemed to be a bug or badly designed, but it makes sense.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now