Error 'Error Evaluating CHECK constraint. ' in the validation rule

I'm getting this error when i try to change/save a record.  I'm merging two apps into one and in order to prevent redundand data entry, i've got the command button on FormA  that opens  FormB to automatically populate the data in the matching fields if it's not already there.  Any Ideas what this error means?  i've never seen it.  I've checked the table for requried controls, but there's only one and it's being populated.  none of the controls on the form have any validation rules and there is no VB on the FormB.  thanks,
matt
matthackneyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SidFishesCommented:
do you have a field named CHECK?...
0
RDWaibelCommented:
Matt,
sounds like you have a relationship issue OR the table you are importing into have a Validation rule with no error text.  You might want to start there.
0
matthackneyAuthor Commented:
i've checked the relationships too.  it is a one-to-many with no referential integrity.  
what do you mean by, "the table you are importing into have a validation rule with no error text."??
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

RDWaibelCommented:
in access, you are allowed at the table level to add to a field a Validation Rule (an expression that limits the values you can enter into that field) and validation text (custome message to allert the user that the entry they are tring to enter is not on the Rule list)

=)  Rob
0
matthackneyAuthor Commented:
yeah, i've checked all the fields on the form at he field level and none of them have validation rules set... and there isn't a field called "CHECK"
0
RDWaibelCommented:
Very odd, The error states that one of the fields in the table (the one you are inserting into) has a Validation rule.

Might want to verify the table you are inserting into, (not the form)

Might also need a repair on your database.
0
matthackneyAuthor Commented:
tried the repair... no luck, can't find anything that has a validation rule in it
0
SidFishesCommented:
i googled a bit and found this error happens when validation rules use "something" instead of [something]

but if you say there's no validation....hmmm...i'm guessing there must be somewhere...just haven't found it yet...
0
RDWaibelCommented:
At this point, I honestly would like to view the database.

You might try creating a new table that is a mirror of the old one and see if you have the same error.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
matthackneyAuthor Commented:
the birthdate field.  i put in a date, it gives me the error... i guess i'll just have to figure this one out on my own.. thanks for your help
0
RDWaibelCommented:
is the field setup as a date?
0
matthackneyAuthor Commented:
yep
0
RDWaibelCommented:
Then, I think I would try a new DB.

Best of luck!

=)  Rob
0
matthackneyAuthor Commented:
that's wierd... i made a new field called DOB, copied the data into it, and changed the name of the control on the form to DOB.. works fine now...
0
matthackneyAuthor Commented:
sid, thanks for your help too.  I didn't see your post at 1:40 until just now.  if i had, i would have split points.  thank you both.
matt
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.