subforms

[Access Virgin]

I have a form with 3 subforms, subform 2 is linked to subform 1 and subfrom 3 is linked to subform 2. I can get subform 2 linked to subform 1 but I cant get subform 3 linked to subform 2.

To link subform 1 and 2 I have used child = Field1 and master = [subform1].Form![Field1]. I thought it would be just the same to link subform 2 and 3, child = Field2 and master = [subform2].Form![Field2] but the when I use this subform 3 doesnt change.

Can the 2nd and 3rd subforms be linked?

 

[misscrf]

I have seen this recently, so you might try this method. Create form1. Then add subform2 to it. Then add subform3 IN subform2. This way, it is looking at what fields to connect 3 with 2, not 3 with 1. If you put form3 as a sub to form1 it wants to connect those two, not 3 and 2. Make sense?

 

[quest4]

Do the respective tables have a relationship? Do all have referential integrety checked? Do all have cascade update and delete turned on? Let just start at the top and work our way down. hth.

 

[Access Virgin]

I have seen this recently, so you might try this method. Create form1. Then add subform2 to it. Then add subform3 IN subform2. This way, it is looking at what fields to connect 3 with 2, not 3 with 1. If you put form3 as a sub to form1 it wants to connect those two, not 3 and 2. Make sense?

The 3 forms, which are continuous form are all on a main form and are positioned below each other, sub1 is linked to the main form, sub 2 is linked to sub 1 and sub 3 is linked to sub 2. Each subform is based on a table and each table is linked together.

As the subforms are continuous i thought that they cannot be combined, ie link subform 2 on subform 1.

Hope this makes sense?

 

[quest4]

Yes it makes sense, but I still would like to make sure that the relationships are correct, I help someone last week with a similar problem and the checkboxes in the second relationship weren't there and when he checked them everything started working. If that doesn't work then make a copy of the dbase and then move subform 2 and 3 onto two separate tabs and see if that helps. hth.