link master field/form to sub-form relationship

[Guest]

Hi,

I am working on a complex database with many related tables and forms with
several levels of sub-forms.

Recently, I have split a very large table into 7 smaller tables to reduce
redundancy. This table was originally used to create a main form that has
several levels of sub-forms. To enable this main form to cycle through
records I created a query that again brought together all the fields from the
7 new tables and set the forms record source to the main field in this query.

Unfortunately, this change has caused problems with my sub-forms. I keep
getting this error...
"The LinkMasterFields property setting has produced this error: 'Procedure
declaration does not match description of event or procedure having the same
name' ".

I would really appreciate it if you could tell me what I should put in the
master link field property box when I have a child sub-form linked to a
master form that draws information from many inter-related tables.

I'm new to all this and could you please explain the syntax of text that
needs to be written in the master link field property.

Any help you could offer would be greatly appreciated.

Cheers,
Luke.

 

[Allen Browne]

The LinkMasterFields property should contain the name of the field on the
main form that is to be matched against the field in the subform (specified
in LinkChildFields).

If the subform is linked just by one field named Field2, set the
LinkMasterFields property to:
[Field2]

From the description of the error message, it sounds like Access is confused
about what you are referring to in this property. Examples:

- The name you used in LinkMasterFields is the same as a property of the
form (e.g. Section, or Name), a reserved word (e.g. Date), the name of an
inappropriate object (e.g. a label, subform control, a module, or the
project) or method (e.g. a function or sub).

- NameAutoCorrect has incorrectly confused two objects. Details:
http://members.iinet.net.au/~allenbrowne/bug-03.html