Subform mystery

[Joe]

Hello.

I have an app where I have a table for Agency data
(AgencyID = pk), a table for Member data (pk = MemberID)
and a table to link them in a many-to-many relationship
(which contains AgencyID and MemberID as its only fields).

I need to display in a subform all of the Memebrs that
work with a given agency. To do this I want to use the
AgencyID of the chosen Agency to locate in the link table
which Members work with that agency. I then want to
display in a subform (?) the member data in Datasheet view.

Does anyone know how to do this?

I tried a previous post's suggestion and I couldn't get it
to display all of the Member data that I need.

TIA,

Joe