Results 1 to 3 of 3
  1. #1
    mokep is offline Novice
    Windows 8 Access 2007
    Join Date
    Jul 2017
    Posts
    6

    Type and then Drop Down Menu Finishes Search


    Hello,

    I'm trying to have a few fields where, when you start typing the input, the choices spelled the same way will show in a drop down menu. For example, if I'm in a Name field, and I start typing "Chr", a dropdown menu would show "Chris, Christie, Christine, Christina". And as I keep typing, such as "Christin", then only "Christine" and "Christina" will show up in the drop down. I know how to make dropdowns in general, but these don't allow the user to start out by typing their answers. I would also like for the user to be able to select more than one option, such as by holding down the control key to select additional options.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Research / Google these terms:

    Find as you type ms access example Here's one from FMS

    Multiselect listbox example

    Also check out this free video by Steve Bishop for ideas.

  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
    The 'drop down menu' is called a Combobox, and what you've described is a default function for Comboboxes. Place a Combobox on your Form, selecting the Field that you populating using the 'I want the Combobox to look up the values in a table or query' option, when it appears. You can then Bind the Combobox to the Field in the Table that it is populating.

    Linq ;0)>

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

Similar Threads

  1. Replies: 2
    Last Post: 05-07-2014, 10:24 AM
  2. Drop Down Help Menu
    By dandoescode in forum Access
    Replies: 1
    Last Post: 08-07-2012, 02:51 AM
  3. Drop down menu help
    By whojstall11 in forum Access
    Replies: 6
    Last Post: 03-07-2012, 01:51 PM
  4. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  5. Drop Down Menu Parameters
    By spoonman in forum Programming
    Replies: 5
    Last Post: 08-18-2011, 02:16 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