By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,762 Members | 1,838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,762 IT Pros & Developers. It's quick & easy.

Form problem - LinkMasterFields error (only when adding a new record)?

geolemon
P: 39
I have a form/subform used for inventory management.
It is a bound form.

The error:
The LinkMasterFields event has produced this error: "The object doesn't contain the Automation object 'Parts'."
I don't understand what this means.

How the form is intended to work:
When you select a part number in the main form, the subform displays potentially several instances of that part number in inventory, and is designed to allow the inventory manager to adjust the quantities for each instance of the part in inventory.

It's bound to a central fact (or matrix) table, which stores key values that relate to dimension tables that describe the attributes of that instance.
My controls in the inner form are drop-downs allowing the user to select valid values from each dimension table, and therefore the appropriate key values are then written to the bound table. Or that's the intention anyway. (ack)
(Parts is one of my dimension tables - the one that contains the part number that corresponds to the part number selected in the outer form.)


The form works fine if an instance already exists in inventory. No problem changing attributes or changing quantity. Press an "Update" control and the record is saved, and a record is written to a transaction log to record the history.

However, if no instance exists in inventory, I should be able to create a new instance in inventory by simply selecting the right combination of attributes from my comboboxes, entering a quantity, and being on my way...

...instead, I'm getting that error.

Is anyone familiar with this error?
What does it mean?
HELP! Very much appreciated!
Jan 7 '09 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Well, when this highly misleading error happened to me it was as a result of a sudden internal failure in the database concerned. For some reason it had become corrupt. I could not fix it no matter what I tried - compact and repair did not help. Deleting the form and importing another copy of the form did not help either, nor did deleting the source query and reimporting that.

The form that gave me the 'does not contain automation object...' message had been working perfectly until then. Thereafter this message occurred when trying to add records.

I reverted to a previous backup to resolve it, but there are other options that may work, including creating a new DB and importing all existing objects in from the apparently corrupt one.

Good luck with resolving it.

-Stewart
Jan 7 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.