Results 1 to 3 of 3
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365

    Detect Click in current row

    Is there a method to know if a click on my datasheet subfiorm (any field) is made in the active (selected) record ?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Not sure I get what it is you're asking. No matter which record a user clicks in, it becomes the active/selected record. In other words, the active record is whichever record is current, no matter when you investigate that. However, maybe what you want is to use either exit, enter or gotFocus for one or more of the controls involved in the records.

    Current event will fire when user selects a different record but not when moving from control to control on the same record. Not sure if that or this will help
    https://support.microsoft.com/en-us/...86553682f9#bm2
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    Thanks @Micron.

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

Similar Threads

  1. Replies: 6
    Last Post: 02-01-2022, 04:38 PM
  2. Detect and Correct
    By Lacresha Miltenberger in forum General Chat
    Replies: 2
    Last Post: 06-26-2017, 11:39 PM
  3. Double Click current record to Edit
    By projectpupil7 in forum Access
    Replies: 18
    Last Post: 11-25-2014, 01:03 PM
  4. Need to detect right arrow key
    By ChuckColeman1812 in forum Programming
    Replies: 4
    Last Post: 09-12-2012, 08:08 AM
  5. How do I detect new records.
    By jcollins in forum Programming
    Replies: 3
    Last Post: 03-17-2011, 03:48 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