Replies

Where are you using that code?
Get back if you need more help.

I tried this in the validation rule of the form for the “meter” box
IIf(“Meter”>”LastMeter”+672,”Then Cancel”=True)

Then I get this error:
there is a type mismatch in the form control validation rule property

Both tables the “meter” and “last meter” are set to “number”.

I apologize I made an error in my original post. I am posting from home since my work computer will not load this website.

I am not using a field “lastmeter”. I am using a calculated field from an expression. I think that is the problem.
I am using this: =[table]![meter]<[query]![expr1]

What code did you try it in the forms BeforeUpdate event?
It should look something like this:

If Meter > LastMeter +672 Then Cancel = True

I will try that.

Exactly where did you put this Validation Rule? You could put it in the [meter] field in the table. In a form, you’d put code in the Form’s BeforeUpdate event to check for this.

I tried it in the table and it didn’t work. I also tried it in the form beforeupdate and it didn’t work. I have tried it the validation rule on the form and it didn’t work.