CODEWITHSUNDEEP
vbams-accessvalidationrule
Thor My
Thor My

Reputation: 299

How to Test Validation Rule Programmatically in VBA/Access

I have the validation rules set in the design table and I want to test it before I save the changes done in the recordset.

Upvotes: 3

Views: 976

Answers (1)

Gustav
Gustav

Reputation: 55831

Use a form to enter the data.

Then use the same validation rules in the BeforeInsert and BeforeUpdate events of the form.

Upvotes: -1

Related Questions