[AccessD] You cannot record your changes because...

William Benson (VBACreations.Com) vbacreations at gmail.com
Mon Oct 24 13:23:39 CDT 2011


I have a form with a data sheet subform. On the current event of the
subform, the values from some of the fields in the data sheet subform are
put into the unbound controls on the parent form.

This was working fine now all of a sudden the form won't open, I get a
message 

"You cannot record your changes because a value you entered violates the
settings defined for this table or list (for example, a value is less than
the minimum or greater than the maximum). Correct the error and try again.

Now, as far as I know I have no validation settings of this kind, and the
table which the subform is based on is a linked table (Excel range).

Does someone have some suggestions for what is possibly causing this?




More information about the AccessD mailing list