Validation error

twitchie

Registered User.
Local time
Today, 05:43
Joined
Jan 16, 2003
Messages
41
My table was fine and I went in to add a field. I did so and got this error when saving:

"Compile error. in table-level validation expression."

I went thru all my fields and I have no validation rules established. I tried removing the field I added and still have the same error. I used the Compress & Repair function and still have the error. After I go thru the dialogs and exit the table design, I re-enter and the new field is there. Any thoughts? Thanks!
 
Not really sure why it worked, but I just deleted the field on the form and then set it up again. That worked. Thanks for your time!

P.S. Just in case anyone else comes up on this problem, the issue was I was using a combo box. For 2 of the options to choose from I used a "<" and ">". That made an expression I guess and Access didn't like that. Just had to change the wording the "less than" and "more than."
 

Users who are viewing this thread

Back
Top Bottom