Automation Error from form

[gemadan96]

I have two forms for a table called Locations. The first is Location List which is a split form contain a datasheet of all the locations. The second is Location Detail where I can view/edit more information about the location. The datasheet contains a link to open the location detail for the selected record. The location detail form has two buttons. One is for Save and New and the other is for close.



If I open the Location Detail form without the location list open everything works fine. If I have the Location List open and then open the Location Detail form the Save and New button works fine. If I click the Close button I get an error. The close button is just a macro with just a close window action.

The error I get is: The object doesn't contain the Automation object 'PID.'

PID is a primary key field in an unrelated table. I've gone through every control on each form looking for a reference to PID in all the properties, macros, and VBA code and have found nothing. I have run a compact and repair and done a decompile and still I get this error.

I don't get this error with any other forms in my application.

[gemadan96]

I also get this same error if I click on the built-in close button in the upper right corner of the window.

[Missinglinq]

The first line of your post explains the problem:

I have two forms for a table called Locations.

Two Forms based on the same Record Source means that one of the Forms will not be editable, since you have the same Record open twice, in different Forms. If you get into Editing the Records, you'll also start having Write Conflicts, always a hairball to sort out!

You either need to have a separate Table for the Location Details, and use a Main Form/Subform scenario, for display/data entry, or open the Form for the Details Table as a popup, or you need to use a a single Form with a Tabbed Control in order to have room to display all of the Fields.

How many Fields does this Table have? As a general rule, if a Table contains more than 25-30 Fields, it is almost sure to be non-normalized.

Linq ;0)>

[gemadan96]

The database was started with the Contacts Management template available from Microsoft. It has a table called contacts. There is a form called contact list. Its a split form that just displays the datasheet listing all the records. There is a text box control that provides a link to open the Contact Detail form for the selected contact. Using the same methods the location table, list form, and detail forms were created. When the detail form is opened, for either table, the list form is not closed, but nothing can be edited in the list form until the detail form is closed.

There are only about a dozen fields in the location table.

The main form/subform is not necessary. This issue does not occur for the Contacts table/list/details or the Promotions table/list/detail.

[gemadan96]

After reviewing yet again the macro in the Location List form that opens the Location Detail form I found the reference to PID. Changed it to LID and now the form closes without an error.

[Missinglinq]

Ouch! PID can be a sore subject! Sorry; that's an insider medical joke!

Glad you got it working!

Good luck with your project!

Linq ;0)>