B
boooney
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.
*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.