Expert: Scottgem - 2/11/2005

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.

HTH
Scott<>