If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Error 3101 cannot find record in the table with key matching field
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. |
Thread Tools | |
Display Modes | |
|
|