Results 1 to 3 of 3
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Event at Record Change

    Hi,



    I have a record with a number of fields. Data is requied in all fields. However, I need to check the data internally among the fields in current record when all fields have data. When I am about to go to another record, I need an event that runs my verifying code. Is there an event like this and if an error is found I shouldn't be able to change record?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    How about the forms Before Update event
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79
    That seems to work.

    Thanks!

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

Similar Threads

  1. Replies: 2
    Last Post: 12-07-2014, 01:15 PM
  2. VBA Programming for After Change() event?
    By mrmims in forum Programming
    Replies: 5
    Last Post: 07-06-2014, 05:47 PM
  3. On Change event in Text Boc
    By quicova in forum Programming
    Replies: 2
    Last Post: 09-12-2013, 01:27 PM
  4. Trying to fire event on record change
    By danielhowden in forum Forms
    Replies: 3
    Last Post: 05-13-2011, 06:30 AM
  5. Replies: 3
    Last Post: 02-19-2010, 04:19 PM

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