Best Place To Do Validation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AricC
    Recognized Expert Top Contributor
    • Oct 2006
    • 1885

    #1

    Best Place To Do Validation

    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
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    Off the top of my head, you generally use the 'BeforeUpdate' version if you want the opportunity to cancel an action.

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      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.

      Originally posted by AricC
      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

      Comment

      Working...