Errors after BeforeUpdate event in form (Access 2007)

[WaltW]

I'm working on a form in an Access 2007 database. I'm using the BeforeUpdate event to validate the data entered into several fields in the form. In every case, no matter how simple the data check, an error message is displayed - generally either "Property not found" or "No current record" - whenever the data is invalid and I set the "Cancel" variable to True. It doesn't seem to matter what field I try to validate, or the form it's on, I always get an error. I've used the BeforeUpdate event many, many times, and never seen this before. All of the attempts have been in the same database (perhaps there's something corrupted in the database?). Does anybody have any suggestions how to fix this?

Thanks!
-Walt

 

[WaltW]

After a little more testing, it appears to give the error messages only when the form is in Datasheet format. The exact same VBA code works fine if the form is in normal "Single Form" mode. Any suggestions would be very much appreciated!

Thanks,
Walt