Linking two subforms

[daved2424]

I have two subforms on the same form. Both of which show data from the same table, just different fields. Is it possible to get the second subform to change on if I select a different record from the first so they are both always showing the same record?

Many thanks for any help in advance.

 

[KenHigg]

One way is to base the second form on a query that has a parameter it gets from the first form.