Results 1 to 4 of 4
  1. #1
    GeorgeJ is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Posts
    67

    What is the event associated with changing the selected record in a tabular form?


    I have a tabular form which uses a Query as its record source. I don't want the user to be able to change any of the data displayed in this form, so I have set to true the "locked" property of the boxes in the detail part of the form which display data from the record source. I would like my program to be able to know which is the currently selected record (the form has record selectors). Is there an event triggered when I click in a particular record selector, and if so what is the name of that event? I would like to be able to attach code to this event.

    Thank you in advance

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    The On Current event fires when the form opens and when the user changes records.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    GeorgeJ is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Posts
    67
    Thank you Paul. That let's me do what I wanted to do. Is there any way on this forum to indicate that a question has been answered, or to give credit to someone who posted a helpful reply?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Your thanks is enough for me! You can mark it solved in Thread Tools at the top of the thread.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 02-06-2015, 01:18 PM
  2. Replies: 1
    Last Post: 07-28-2011, 08:34 AM
  3. Replies: 2
    Last Post: 07-24-2011, 08:50 PM
  4. Replies: 1
    Last Post: 11-24-2010, 09:51 AM
  5. tabular forms - setting values per each record
    By Daytona675 in forum Forms
    Replies: 0
    Last Post: 11-25-2008, 09:43 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