LinkMasterFields property setting error

[ggregory9]

I have a data entry form with 2 subforms based on a master table and 2 many to one tables. THe key field on the master table is an autonumber field called ID. I have added ID fields as long int on the related tables. These fields are linked as master and child on the subform properties. I am getting the following error when I open main form: "TheLinkMasterFields property setting has produced this error: procedure declaration does not match description of event or procedure having the same name". Any idea what is causing this error?

 

[dhookom]

What are the names of your linking fields?
What happens if you remove the values from these properties?

Duane
Hook'D on Access
MS Access MVP

 

[ggregory9]

The name of the linking fields on the subform tables is 'ID'. What do you mean by removing the values from the properties?
I have written some VBA code but am not an expert by any means.

 

[dhookom]

What do you mean by removing the values from the properties?

Just find the properties and delete the ID field names from them both. I would like to know if this fixes your issue.

So you are stating the primary key field name is ID and the foreign keys in the related table(s) is also ID. The primary key [ID] field in Autonumber and the ID fields in the related table(s) is numeric long?

Duane
Hook'D on Access
MS Access MVP

 

[ggregory9]

Yes the primary ID field is autonumber and the ID fields in the related tables are numeric long.
Which properties are you suggesting I remove values from. There are form properties, subform properties, section properties, field properties.

 

[ggregory9]

I removed the After Update event on the main form where I was trying to populate a 'dateupdated' date field and the error went away.

 

[dhookom]

Which properties are you suggesting I remove values from

master and child on the subform properties

I have no idea why your after update would affect the link master/child.

Duane
Hook'D on Access
MS Access MVP

 

[ggregory9]

I know - I don't either. Thanks for trying to help me.

 

[dhookom]

You never shared your code so it is remote that anyone can help.

Duane
Hook'D on Access
MS Access MVP