Data Validation Messages Problem

[saleemMSMS]

hi
i have a form with several fields in it.

Name :---
Address :-----
Telephone :-----

all the fields are having validation rules and validation texts..
my problems is in the forms. whenever i miss entering something a message prompts saying that the particular column cannot be null. this message appears to all the 3 columns. and is annoying.
is there a way of having just one message instead of individual messages to all the text boxes in a form ?
so in the time the data goes to the table it will check whether the text boxes are empty and then prompt a message ?
btw, what is the event i need to trigger to the data entering stage ?

 

[shadow9449]

Assuming that the user is entering the data through a form, the best place to put the checking is in the BeforeUpdate routine. That way the problem is caught before the data is written to the table. You can cancel the writing to the table if the data doesn't meet your criteria.

SHADOW