table/control validation

Topic

New Reply

Post deleted by jp2558

Reply | Quote

Replies

The rules are additive – if any of them (control, field in a table, or table) fail, then the validation fails. So, no, you don’t need to put validation rules on your controls if they are already on the fields of your tables. Quoting from the Access 2000 help (and it also applies to Access 97):

[indent]

---

Order of validation for controls and fields
Validation rules for controls and fields are evaluated in the following order:

Macro or event procedure validation (for example, a macro or an event procedure that responds to the BeforeUpdate event of the control or the form containing the control)

The control’s ValidationRule property

The underlying table’s validation rules for the field (as set in the field’s ValidationRule, Required, and AllowZeroLength properties)

The underlying table’s ValidationRule property (this property performs validation on records)

---

[/indent]

Reply | Quote