Linking Subform

[SVNTY7]

Is it possible to have a subform1 linked to the main table, then to have subform2 linked to subform1?

If so, how ?

Thank You

77

 

[Fizzio]

Yes it is possible and there are 2 ways (I know of anyway) that you can do it.
1) Base the second subform on a query with the linking criteria taken from the first subform eg
1st subform = Orders
2nd Subform - OrderDetails

1st Subform linked to Mainform by Master/Child CustomerID
2nd Subform NO master/child link but in Query supplying 2nd subform,
in OrderID criteria : =Forms!NameofMainForm!NameOfSubform1!OrderIDControl (I would check the subform syntax of this though)

2) Use a master/child link from the 1st subform to the 2nd subform (A little more tricky)

Get back if you need more clarity!