Error Message 'Error evlauation CHECK constraint. 'in validation r

[Guest]

Every time a switch my form to form view and test the fields by putting the
information in and then try to return to design view I get this error message
"Error evaluation CHECK constraint. 'in validation rule." Does anybody know
what this means?

James E.

 

[Michel Walsh]

Hi,


Your form involved a form that has a CHECK constraint. There is no
UserInterface that allows you to see those constraints. If the constraint is
not otherwise documented, it can be found, with some detective work, in the
system tables. You need to spot its name. When you have the name of the
constraint, you can

CurrentProject.Connection.Execute "ALTER TABLE tableNameHere DROP CONSTRAINT
constraintNameHere"


in the immediate debug Window.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Thank you, this is very helpful!

James Eggert

Hi,


Your form involved a form that has a CHECK constraint. There is no
UserInterface that allows you to see those constraints. If the constraint is
not otherwise documented, it can be found, with some detective work, in the
system tables. You need to spot its name. When you have the name of the
constraint, you can

CurrentProject.Connection.Execute "ALTER TABLE tableNameHere DROP CONSTRAINT
constraintNameHere"


in the immediate debug Window.



Hoping it may help,
Vanderghast, Access MVP