Value not valid for this field (run-time error '2113')

[cebrower]

I have a form named frmConfirmEdit with a text field named ConfirmationNumber. In the On Load event of frmConfirmEdit the confirmation number is written to an unbound field on a different form so code in other forms, reports, etc. can refer to it. This has worked fine for years. Today, when I open frmConfirmEdit I get the message "The value you entered is not valid for this field. Run-time error 2113". There are 200 records in the record source for frmConfirmEdit. I only get this error for one of those records. The form opens properly for any of the other records. I've run Compact and Repair on both the front end and the back end databases, I've decompiled and recompiled the front end, I've manually re-typed the value in the table, and I've deleted and recreated the record. Still get the error. Any suggestions?

[orange]

Where is the backend Access, sqlserver...)?

I found a thread that discusses that 2113 error and CajunCenturion has an answer near the end of the thread.
Don't know if it is similar to your situation, but you may get some insight from that thread.

[cebrower]

Problem solved: The record source query for frmConfirmEdit has a field in tblConfirm named [TaxCode] that links to tblTaxInfo!TaxCode, but it was null in tblConfirm so no record was returned. The lesson is that the error message does not always lead you to the actual problem.

[orange]

Good stuff. Thanks for posting your findings.

[Missinglinq]

...The lesson is that the error message does not always lead you to the actual problem...

Sadly, Access' error messaging system is not the best in the world! Also, when you break on an error, the line hi-lited is not always the line causing the problem...it is often the line preceding that line!

Glad you got it figured out!

Linq ;0)>