Form\Subform\Subform

[stephendeloach via AccessMonster.com]

I have a form with a subform and a subform inside the subform.
(Form/Subform/2ndSubform) When I go to a new record in the Form all the
fields in the Subform/2ndSubform are blank, which is good. When I go to a new
record in the Subform the information in the 2ndSubform stays the same.. I
need these to go blank... My realtionships are

tblMain tblVendor tblDescription
ID ------------ IDNum ------------ IDNum

Any suggestions?

 

[Allen Browne]

1. From the database window, open the first subform in design view.

2. Right-click the edge of the subform control (i.e. the thing that ends up
being your innermost subform), and choose Properties.

3. On the Data tab of Properites, set the Link Master Fields and Link Child
Fields. Set Link Master Fields to the IDNum (if that's the tblVendor key
field), and Link Child Fields to the matching field in tblDescription (the
one that matches the vendor key field.)

Access tries to set these for you, but doesn't always get it right.