Dynaset inconsisent interfering with my linked tables

Posted on 2009-04-25
Last Modified: 2013-11-29
Hi - I have a query that is made up of several tables, some of which are linked fields so that change the value of other fields (for example, select NJ and New Jersey pops up in a corresponding field; select CT and Connecticut appears in a corresponding field, etc.).

I set the form to Dynaset Inconsistent (as I understand I am to do because the query is made up of multiple tables), however, when I do so the fields that have linked tables (i.e. NJ and CT) no longer update the corresponding fields.

Do I "need" to do dynaset inconsisent?  If I remove this, the problem is solved (although I am fearful it may create other problems).  Or is there a way to maintain the integrity of the linked tables/corresponding fields?

A sample attached
Question by:daisypetals313
    LVL 74

    Accepted Solution


    <I set the form to Dynaset Inconsistent (as I understand I am to do because the query is made up of multiple tables),>
    From what source did you get this information from?

    As far as I can tell, there is no reason to turn on Inconsistient Updates in your query.
    Unles you can state a specific issue that turning Inconsistient Updates on will fix, then leave the Recordset Type property set to: Dynaset

    Another note:
    Most developers cringe when lookup Fields are used in the Tables.
    Create your Lookup comboboxes in the form.
    It is just as easy.
    Drop a combobox on the form and follow the wizard ("I want the combo box to look up...")


    LVL 39

    Expert Comment

    You can change the form's dataset type to "Dynaset (Inconsistant Updates)" to make the form updatable in some cases.  If the form in updateable with just Dynaset, them you do not need to use "Dynaset (Inconsistant Updates)".  If that doesn't work, you need to change the query or use Update or Insert queries to update the data.  Type "When can I update data from a query?" in MSAccess help answer wizard for more information on when queries (datasets) are updatable or check this link:;en-us;304474#XSLTH4225121123120121120120
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

    732 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

    23 Experts available now in Live!

    Get 1:1 Help Now