AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question "The Microsoft Jet database engine cannot find a record in the table
'tblOrgs' with key matching fields(s) 'tblDocs_fldOrgId.'
This is the error that pops up when I try to create a record... I've tried
everything countless times, but I can't fix it! Please help! The tiny
database is zipped up and ready to send.
I've got a main form with two combo boxes, some text boxes, and a datasheet
view of a subform on it. If I enter stuff into the combo boxes and text
boxes on the main form first and then go to the datasheet, I can almost
create a new record, but the error message pops up.
If I populate the datasheet first, the error pops up as soon as I click one
of the combo boxes.
Help!
Answer What I think the message means is that the subform linking field isn't finding a match.
If there is a Debug option when you get this error, press it and look at the code its highlighting. If there isn't, you need to look at the the linking fields between the main and subform, whether you are saving the record properly or the Before Insert event of the subform.
