Results 1 to 5 of 5
  1. #1
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107

    Form click event


    Is there an event for a datasheet that triggers if any of the cells is clicked?
    I tried the Form.click() event, but it is works only if the user clicks on the headings of the datasheet and not inside the cells.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Would require code in each control's Click event. What exactly are you trying to accomplish?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    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
    And you'd probably want to use the Control's Double-Click event...allowing the user to single-click into the Control in order to enter data, if need be.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    I have a form and a subform, I want to hide a control in the form every time the user clicks inside the subform ( of course with some other conditions to be checked)
    I solved the problem using subform_enter event.
    Thank you guys

  5. #5
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    Interesting and thanks for posting what actually worked for you...

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

Similar Threads

  1. Access On Click event not working on form
    By bmanning20 in forum Forms
    Replies: 2
    Last Post: 10-17-2017, 06:07 PM
  2. Replies: 13
    Last Post: 09-10-2015, 03:37 PM
  3. Click event of form?
    By BLFOSTER in forum Programming
    Replies: 3
    Last Post: 04-25-2014, 11:29 AM
  4. Dbl Click Event on Form Header
    By drunkenneo in forum Forms
    Replies: 1
    Last Post: 11-18-2013, 04:04 AM
  5. On Click Event For Button On Form
    By Desstro in forum Forms
    Replies: 3
    Last Post: 08-09-2010, 02:36 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