linking error

[Nyanzi]

Hi,
I am trying to link my subform to its main form. When I try to update the link child field and the link master field under the subform properties, i get the error " Can't build a link between unbound forms". When i inserted the subform, i as not given options of which fields to link it to. I have done it before but now i am failing. please help

 

[scriverb]

This is correct. The links between the two forms are based upon table field names. Since your main form and your subform are unbound there are only controls which are not assigned a Control Source property value.

You just can't conceptually have an unbound subform on a main form. The subform has no records to link to. Your mainform has no records to link to. When you load a record in the main form manually using VBA code there are still no associated records in your unbound subform to display.

Do you see the dilema that you have created here.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]