Data validation in forms

[chrisjames25]

Hi.
.
When i learnt to use vba in excel (to basic level) i was always advised in a userform to validate data at end of record input ie when pressing enter and next. Is this true also with access or should i be putting validation rules at the afterupdate stage of a particular control?

 

[bob fitz]

Hi.
.
When i learnt to use vba in excel (to basic level) i was always advised in a userform to validate data at end of record input ie when pressing enter and next. Is this true also with access or should i be putting validation rules at the afterupdate stage of a particular control?

I suppose it depends on you're actually doing but generally I would say that validation is best done in a forms Before Update event.