Hi RuralGuy
Thanks for your interest.
I have 4 tables.
tblHousehold .
tblPeople (in a household).
tblGroups (some people are scheduled to attend a focus group on a particular day).
tblProjectPeople links the people to the focus groups and has 2 fields, the personkey and the groupkey.
I have 3 forms
frmHousehold, a subform called frmPeople (which is built around a tab control), and a subform on one of the tabs called frmGroups. frmGroups shows if any people in a particular household are scheduled to attend a focus group.
I also have a form called FilterByForm which contains code and which allows my users to build queries into the db (e.g show all people living in Essex who have 3 children)
When I open the FilterByForm the InsertSubdatasheet dialog appears.
By the way , FilterByForm is an item I bought in for £20 and which (in previous versions of my DB) has been invaluable. I've experimented with all sorts of ideas, I've explicitly created subdatasheets in the relevant tables, I've removed all the subdatasheets and some other things.
Any ideas appreciated.
Thanks