Using a subform to select records in another subform

[druss74]

I have a table setup such as Houses, Rooms, Itemsinroom, partsofitems. All
linked on to many. I want create a form based on the rooms table that has a
subform for the itemsinroom table, this subform would then have a
subdatasheet for the partsofitems.

I would like to put a subdatasheet on the mainform also based on the
itemsinroom table that i can use to select the record viewed in the in the
itemsinroom subform.

I can use a list box instead of a subdatasheet to select the record but
there is not enough control over the way it displays data.

Can anyone help me