Subform Error

[Naia]

I have a subform in a form. I have linked the forms together with a common field. Whenever one clicks into the subform, they receive this error message:

The LinkMasterFields property setting has produced this error: 'The object doesn't contain automation object 'subform_name."

Please help me fix this.

Thanks, n

 

[MStef]

Check LINK MASTER FIELDS and LINK CHILD FIELDS properties.

 

[Naia]

Master/Child Properties

My field properties are set as such:

Source Object: Pro1-1ASTM
Link Child Field: RID
Link Master Fields: Header.RID
Enabled: Yes
Locked: No
(see attached picture)

I tried changing the master field link to just RID, but when I switch from design view to form view the subform box displays empty. I have also tried square brackets around the mast field link (ex: [Header.RID]). Also, the main form was generated using a querey, the two table from the querey have the RID field in common. I am rather perplexed by this problem because I have just started experiencing it. I have generated similar past forms in the same manner and not experienced any problems.

Thanks, N

 

[boblarson]

Change your Master field location to

RID

from

Detail 1-1ASTM.RID

It doesn't need that other part in there. It knows what forms you have as your main and subform.

 

[Naia]

I tried that

If I remove the Header portion the subform appears blank when I return to form view. It also give the error: The text you entered isn't an item in the list. Select an item from the list or test that matches an item on the list.

 

[boblarson]

can you post your db?

 

[Naia]

Database Example

See attached for example of problem

 

[boblarson]

If Header and Detail are One-To-One then they should all be in one table. There's no reason for them to be in separate tables. If they are not supposed to be one-to-one but one-to-many then you don't have this set up right. The header would then be on the main form, the detail table on the first subform and the data table as a subform on the first subform.

 

[Naia]

Relationships

How can I change the relationship from 'one to one' to 'one to many'?

 

[Naia]

The tables do need to be separate. I cannot post my entire database due to size and confidentiality reasons. I think I have fixed the relationships, but the subform is still not working. Does anyone know how to fix it?
Thanks

 

[MStef]

Hello Naia Suszek!

Because I don't know your task, I improvised something.
I made a "MainFormHeader", "Subform1Detail 1-CEN" and
"Subform2Data1-1CEN".
I made some changes in the tables and Relationships.
I entered 2 records in "Subform2" (in RID 08L999, f1ID 2).
MainForm is a Single Form (Default view),
Subform1 is a Single Form
Subform2 is a Continuous Form.
You have got 3 NAVIGATIONS BUTTON.
For every "RID" you can enter more records in Subform1,
for every "f1ID" (Subform1) you can enter more records in Subform2.
I think it can help you.