+ Reply to Thread
Results 1 to 7 of 7

Open Database Form on Double-Click on record

  1. #1
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Open Database Form on Double-Click on record

    Hoping there is an Access guru here.

    In my attached project, there is a form called frm_Partner.

    There is a subform in this form on the right hand side that drills down to a booking (Tracking Ref#) and reschedule (Reschedule#).

    I want to be able to double-click in the 'Reschedule #' field and bring up the form frm_Reschedules showing the record for the 'Reschedule #' AND 'Tracking Ref#' as this is the primary key.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: Open Database Form on Double-Click on record

    Seems like it is working as needed. When I double click on the Reschedule # , it opens the record. What am I missing here?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Open Database Form on Double-Click on record

    It's not opening the correct record based on the Tracking Ref# and Reschedule #.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: Open Database Form on Double-Click on record

    Administrative Note:


    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  5. #5
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Open Database Form on Double-Click on record

    Yep. I posted on another site but as it was my first post there it had to be approved by an admin so I didn't know what the link was. I'll post it asap.

  6. #6
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Open Database Form on Double-Click on record


  7. #7
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Open Database Form on Double-Click on record

    Wow in infraction! Blessed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. double click open folder
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2018, 05:08 PM
  2. Double click on cell > Open User form > insert value
    By amein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2016, 05:24 AM
  3. stoping duplicate record of data with double click of macro button
    By ajleeds in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2014, 10:43 PM
  4. Calendar open with a double click
    By nik7 in forum Excel General
    Replies: 8
    Last Post: 04-08-2013, 07:54 AM
  5. [SOLVED] Open a new form, create new record based on current form / record
    By Cyclops in forum Access Tables & Databases
    Replies: 4
    Last Post: 01-28-2013, 06:36 PM
  6. double click to bring up form
    By simpo067 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2009, 10:35 AM
  7. Double Click will not open my Workbook
    By Stacy in forum Excel General
    Replies: 3
    Last Post: 04-13-2006, 02:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1