record level validation

[SunWuKung]

Could somebody point me to some online resources about record level validation in Access.

Thanks.
SWK

 

[llkhoutx]

Look at Litwin, et al's, Access Developer's Handbook. Theree's an edition for each version of Access.

Otherwise, on event (form) BeforeUpdate do what ever validation is required. One can set the tag for each object requiring validation and check appropriately on (form) BeforeUpdate. Object event BeforeUpdate can also be used.

 

[llkhoutx]

You can also use a Default Value and Validatation Rule & Text in your tables' design.

I find it easier to validate with VBA code on BeforeUpdate, that way your validation code is all in one place.