Error 3101 in Access 2013

Question

I have an error 3101 message in my desktop database (Access2013). I do have a one to many relationship, but the "many" side does have a corresponding record on the "one" side, but I get the 3101 error anyway. How can that happen?

Bioern Veiroe

Answer 1

(in the Immediate window)
?AccessError(3101)

The Microsoft Access database engine cannot find a record in the table '|2' with key matching field(s) '|1'.

This is why we ask to quote all error messages VERBATIM. In this case it would help to know the replaceable parameters.
I am assuming you have an enforced relationship between the two tables. Good! Keep it that way.
When this error occurs, you should hit Ctrl+Break to break into the debugger, and see where the error is being generated. Show us that code. Inspect the variables in the procedure to determine if they have the expected values. It is very likely you have an unexpected foreign key value that was almost being saved to the child table.

Answer 2

I entered the Ctrl+Break as recommended, but nothing happened. I have tried to activate the debugger when I enter the main form, where the problem occurs in one of its subforms, but though I could see that the debugger was active, it did not seem to be the case in the subform with my problem

Biorn Veiro

Answer 3

I added a comment with the verbatim message you required.

What is the difference between a comment and an answer?

Biørn Veirø