Results 1 to 4 of 4
  1. #1
    Kylie is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    7

    Navigation Button


    Hi, I would like to make sure a procedure is run when the user changes from one record to the next by clicking through the navigation buttons. Does anyone know how I can capture if the user has moved to a different record through VBA?
    Thanks in advance

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The Form_Current event is the one that fires when moving from Record-to-Record:

    Code:
    Private Sub Form_Current()
     'Code goes here 
    End Sub

    Linq ;0)>

  3. #3
    Kylie is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    7
    Yes it works great - thank you

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Glad we could help!

    Linq ;0)>

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

Similar Threads

  1. Replies: 10
    Last Post: 11-27-2016, 11:04 PM
  2. Replies: 2
    Last Post: 11-10-2014, 06:22 PM
  3. Replies: 5
    Last Post: 02-07-2014, 08:37 AM
  4. Replies: 9
    Last Post: 11-27-2012, 07:56 PM
  5. Print Button on a Navigation Form
    By sotssax in forum Forms
    Replies: 2
    Last Post: 09-15-2011, 07:47 AM

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