Why does the Master Field want to be updated?

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 http://www.sscash.com/VendorTest.mdb if needed.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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'


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.