Error 3101 cannot find record in the table with key matching field

Hi--
*I have a form called 'projects' based on table 'projects' and within that
(linked by 'project_ID') is
*a subform called 'project scope' based on a query of 2 tables and within
that (linked by 'project_scope_ID') is
*a subform called 'contracts' based on a query of 3 tables

I can add fields to the subform 'project scope' from 'projects,' but when I
try to add fields to the subform 'contracts' from either 'project' or
'project scope' I get the following error messages:

first: "the object doesn't contain the automation object 'contracts' then
second: "The Microsoft Jet database engine cannot find a record in the table
'project scope' with key matching field(s) 'contracts.project_scope_id.
(Error 3101)"

the 'project scope' field exists in both the parent and child tables.
Apparently when I'm opening up the subform, it's not autofilling the child
'project_scope_id' from the parent 'project_scope_id'

Any idea what I'm doing wrong? This is driving me nuts. Thanks.

Never mind...I redid from scratch the subform at the bottom that I was having
trouble with and it now works.

"boooney" wrote:

Hi--
*I have a form called 'projects' based on table 'projects' and within that
(linked by 'project_ID') is
*a subform called 'project scope' based on a query of 2 tables and within
that (linked by 'project_scope_ID') is
*a subform called 'contracts' based on a query of 3 tables

I can add fields to the subform 'project scope' from 'projects,' but when I
try to add fields to the subform 'contracts' from either 'project' or
'project scope' I get the following error messages:

first: "the object doesn't contain the automation object 'contracts' then
second: "The Microsoft Jet database engine cannot find a record in the table
'project scope' with key matching field(s) 'contracts.project_scope_id.
(Error 3101)"

the 'project scope' field exists in both the parent and child tables.
Apparently when I'm opening up the subform, it's not autofilling the child
'project_scope_id' from the parent 'project_scope_id'

Any idea what I'm doing wrong? This is driving me nuts. Thanks.