By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Best Place To Do Validation

Expert 100+
P: 1,892
When is the best time to run a validation check? I've read some places to do the check on the forms before_update command, however does this work if you've hard the coded the inserts on a custom button? Does it really matter as long as it gets done?
TIA,
Aric
Oct 23 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,275
Off the top of my head, you generally use the 'BeforeUpdate' version if you want the opportunity to cancel an action.
Oct 24 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
I'm inclined to use AfterUpdate myself. Most of the time it doesn't make much difference.

However, most of the expert experts recommend using BeforeUpdate. Something to do with how the Jet Engine behaves in certain conditions doing an update.

When is the best time to run a validation check? I've read some places to do the check on the forms before_update command, however does this work if you've hard the coded the inserts on a custom button? Does it really matter as long as it gets done?
TIA,
Aric
Oct 24 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.