Save a Record

[sajitk]

Hi Friends,

In Access, the data in a form gets saved even if there are null values in the form. Wat I want is to check this i.e. if there is a Null Value in a particular field or if the user tries to move forward or backward without entering the data, then that particular data should not be saved.

Pls suggest.

Sajit

[ADezii]

Hi Friends,

In Access, the data in a form gets saved even if there are null values in the form. Wat I want is to check this i.e. if there is a Null Value in a particular field or if the user tries to move forward or backward without entering the data, then that particular data should not be saved.

Pls suggest.

Sajit

Simply set the Required Property of the Field in question in the underlying Table to Yes.