Results 1 to 3 of 3
  1. 10-09-2016, 03:07 AM #1
    vazdajic
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95

    Search as you type - Double click on name to jump to the record

    Hello there.. I have successfully implemented "Type to Search" into my test database.



    As I type, the list narrows down, so eventually, when I see the record I'm looking for, I would like to jump to it when I double click it in the list.. How can I do that.

    Thanks.

    Click image for larger version.  Name: Double click to jump to the record.jpg  Views: 24  Size: 181.0 KB  ID: 26074
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 10-09-2016, 03:51 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Perhaps you could apply a filter to the form. See db attached.
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 10-09-2016, 06:46 AM #3
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    not tested but perhaps include in your change event code something like

    if me.subformname.form.recordcount=1 then me.subformname.setfocus
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Double click on record in list box to open record above
    By clyle in forum Access
    Replies: 8
    Last Post: 02-04-2016, 05:10 PM
  2. simulate double click in record from subform with a button
    By megatronixs in forum Forms
    Replies: 1
    Last Post: 07-14-2015, 05:59 AM
  3. Double Click current record to Edit
    By projectpupil7 in forum Access
    Replies: 18
    Last Post: 11-25-2014, 01:03 PM
  4. Opening records via Double-Click event on a search form.
    By IncidentalProgrammer in forum Programming
    Replies: 4
    Last Post: 11-21-2014, 03:47 PM
  5. double click to a record and open a new form
    By webisti in forum Forms
    Replies: 10
    Last Post: 02-20-2012, 11:25 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums