Solved Record Validation Equivalent in Event Forms

[anski]

In the general tab of Table Property, there is the Validation Rule. What is the equivalent Event of this in forms? I cannot seem to make it work using On Current and Before Update in forms.

I do not want the cursor to move on to the next record if the sum of field01 and field 02 is zero.

 

[theDBguy]

I think you're looking for the Before_Update event of the control itself.

 

[jdraw]

Can you give us sample data that illustrates the issue?

As DBG said Before Update, and perhaps Before Insert might apply.

 

[anski]

Before Update worked. I just had to clean up the data as there were records that violated the validation rule. Thanks.

 

[theDBguy]

Before Update worked. I just had to clean up the data as there were records that violated the validation rule. Thanks.

Good job. Good luck with the rest of your project.