Results 1 to 3 of 3
  1. #1
    larrywang is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2015
    Posts
    9

    table validation rule vs Form before update validation

    Hello gang, I am trying to understand which is preferable method. Use vba on form property events to validate inputs before update or simply when creating tables under validation rules spell out the validation. I think both achieve the same things i.e. conformity before putting records down to tables. However what is the difference and similarity between these two.

    Thank you in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I use code on the before update.
    its more a pain to put it in the tables, ESP in a split db....if you need to change rules, you must get everyone out of the db to change.
    Plus importing data can cause errors too.

    i think code way is just easier to me.

  3. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I also use beforeupdate - you can make the messages more helpful for the user

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Struggling with a validation rule / before update
    By thompjas in forum Programming
    Replies: 6
    Last Post: 02-19-2015, 07:18 PM
  2. Replies: 2
    Last Post: 12-27-2013, 07:32 AM
  3. Validation Rule by relating the data with table
    By Falahuddin in forum Access
    Replies: 14
    Last Post: 12-23-2013, 07:15 PM
  4. Replies: 2
    Last Post: 10-25-2012, 02:39 PM
  5. Validation Rule in Table vs. Form
    By LanieB in forum Forms
    Replies: 2
    Last Post: 03-12-2012, 03:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums