Why does the Master Field want to be updated?

Posted on 2004-11-04
Last Modified: 2012-05-05
A2000 XP

I have a form with a ComboBox bound to a table containing Vendor Names.  It also contains a subform with a TextBox bound to an AreaNames table that displays the areanames associated with the Vendor Names displayed in the ComboBox.

The subform wrapper links the two forms with the "Link Master Field" pointing to the ComboBox and the "Link Child Field" pointing to the vendor name col (vendorId) in the AreaNames table.

I can open the form and it will display the areanames based on the default for the combobox and allow me to exit the form with no problems.

However, if I select different vendors from the combo dropdown, it will correctly display the area names for that vendor in the subform but when I try to exit the form, it wants to update the vendor record and claims it can't because one of the fields in the vendor record contains null values.

I don't want to update the vendor records and have tried variations trying to avoid this problem.

How can I get around the problem of the Vendor table being updated?

A copy of the test db can be found at if needed.


Question by:katzwhite
    LVL 2

    Accepted Solution

    Instead of using linkmaster / child, use a query for 'Areanames_PopUpSubWrapper' with this type of criteria to filter vendors:


    then use me.Areanames_PopUpSubWrapper.requery in on click command for 'VendorNameBox'

    LVL 41

    Expert Comment

    I don't know how you are displaying area names, but the combo that shows vendors should not be bound to a field. You should also not have any code that actually changes values in textboxes in the subform (as opposed to setting filters or record sources).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    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…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    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…

    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

    12 Experts available now in Live!

    Get 1:1 Help Now