I am using access 2.0. My question is how come if I use the validation part on a form and if there is a date that has the is not null. On the table there are other fields that this always happens to take presidecne in error checking.


Also if I put this error checking just on the form and take it off the table. It doesnt check for is not null and save it. But if I check for is null it will give an error message.


The next question I am trying to turn off warnings for cancel=true. Becasue I have an error check. I already have a message box that pops up to the user. Access says invalid reference to field on form before update. in the before update I put the command
DoCmd Setwarnings falase

I am using access 2.0 thanks you in advance.


Rob