Results 1 to 2 of 2
  1. #1
    megatronixs is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    91

    simulate double click in record from subform with a button

    Hi all,



    I'm trying to simulate a double click on a record from a subform. Now I have a subform inside the main form that needs to be hiddine. As of that I can't use the double click on the record to open it on the main form.
    Any idea if this can be done?
    The subform is in datasheet view and I need to click always the first record [ID].

    Greetings.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    use the BUILDER to construct the correct path to the sub form text box...

    on CLICK event

    Code:
    me.filter = "[clientID] = "  & forms!frmMain!sub!forms!txtClientID
    me.filterOn = true

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

Similar Threads

  1. Replies: 2
    Last Post: 11-14-2014, 03:07 PM
  2. Replies: 2
    Last Post: 10-29-2014, 03:25 AM
  3. Replies: 7
    Last Post: 06-24-2013, 05:43 PM
  4. Replies: 3
    Last Post: 10-04-2012, 01:33 PM
  5. On Double Click go to Subform
    By Theremin_Ohio in forum Access
    Replies: 2
    Last Post: 03-30-2011, 08:03 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