error msg

[aubrey]

Hi,

I've created a form and i'm trying to enter data. Whenever I try to save
that data i get an error msg,
"Error ‘Error evaluating CHECK constraint. ‘ in the Validation rule."
I have validation rules on any of the fields of my form.

I know this is a bit vague, but any help would be appreciated.

 

[Klatuu]

The validation rule you are violating is probably defined for a field in the
table.
Open the table in design view and look for a validation rule in each field.

 

[aubrey]

There is no validation rules in any of the fields in the table.

 

[Klatuu]

There has to be some validation rule somewhere.
Based on the message, it probably is not in the form or its controls, it is
most likely in the table. If you don't have any validation rules for any
fields, then either there may be an index defined that is preventing the
entry.

 

[aubrey]

I also taught it was a index definition that was causing the error, so i
deleted all of them.

 

[Klatuu]

Is the form based on a query or directly on a table?
If it is a query, is it based only on one table?
Is your application split? If so, is the back end an mdb or some other
database engine?
Have you done a compact and repair on the database where the table is and on
the one where the form is?

 

[John W. Vinson/MVP]

"Error ‘Error evaluating CHECK constraint. ‘ in the Validation rule."
I have validation rules on any of the fields of my form.

CHECK Constraint *sounds* like you have your data stored in SQL/Server
and that there is a Check Constraint defined on a field, as a
validation rule. Where is your data stored?