linking two subforms

  • Thread starter Thread starter Flavi Gobson
  • Start date Start date
F

Flavi Gobson

Hi,

I have created two subforms: one is based on a query and
the other is based on a table. Both query and table are
containing the same values, but the query is a summary of
the most important ones.
Now, the first subform (based on the query) is in database-
view. When I select one line in this subform, I would
like to see, in the other subform, the fields linked with
this line.
Any ideas on how to do this?

thanks in advance

Flavi
 
Chris,

Does this really work for you? I've tried it without success. The idea makes
sense but it's not happening for me. Is there a version dependency? I'm
using Access 2000.

Earl


Chris Large said:
Hi

Set the second subForm control's Link Master Fields
property to this:

[name of first subform control].Form![Key Field]

the Link Child Fields property should then be set to

[Key Field]


As the record selected in the first subform changes the
second subform will be automattically changed to match.

hth

Chris

-----Original Message-----
Hi,

I have created two subforms: one is based on a query and
the other is based on a table. Both query and table are
containing the same values, but the query is a summary of
the most important ones.
Now, the first subform (based on the query) is in database-
view. When I select one line in this subform, I would
like to see, in the other subform, the fields linked with
this line.
Any ideas on how to do this?

thanks in advance

Flavi
.
Click to expand...
Click to expand...
 
Back
Top