Validation Rule

[Markus]

Hallo

I have a problem i want to do some validations once a user clickes on the
close button or new product button the validation works fine but if I am on a
blank record that and I click on the close button it comes with a error.

Basically what I want it to look is the record number blank (autonumber)
then close the form with out doing any validations else if the record number
is not blank then do validations.

Any ideas

Markus

 

[Allen Browne]

Move the validations into the BeforeUpdate event of the *form* (not the
event of a control.)

This event only fires if there are changes to be made.