Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Allow a user to select a name from a long list

Discussion in 'Information Technology' started by PaulM, Nov 19, 2005.

  1. PaulM

    PaulM
    Expand Collapse
    Guest

    I am about to create a database that will allow a user to view information
    about an individual from a database of 2000+ records. The list of names will
    be such that a list or combo box would be too long and unwieldy. On a form,
    I want the user to begin entering the name required and for the name and
    associated details to be revealed. Any help gratefully accepted.

    Thank you for your help
     
  2. Loading...

    Similar Threads Forum Date
    Are Sikhs Allowed To Fish? Hard Talk Aug 28, 2016
    Sikh News Allow Turbaned Sikh Basketball Players: US Lawmakers - Chandigarh Tribune Breaking News Aug 4, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    Rehras at Halloween Blogs Oct 31, 2015
    Sikhi allows Worshiping of only Akaal or all the Gurus??? Questions and Answers May 1, 2015

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "PaulM" <PaulM@discussions.microsoft.com> wrote in message
    news:B6F5A61E-E110-4C98-891F-9876DDC03103@microsoft.com...
    >I am about to create a database that will allow a user to view information
    > about an individual from a database of 2000+ records. The list of names will
    > be such that a list or combo box would be too long and unwieldy. On a form,
    > I want the user to begin entering the name required and for the name and
    > associated details to be revealed. Any help gratefully accepted.


    Couple ways to go...

    You can overlay a TextBox on your ComboBox and use the Change event to count
    characters entered. Once the desired count is achieved you take that text and
    use it to apply a filter to the ComboBox RowSource, move focus to the ComboBox
    and then drop the list. In most cases just a few characters is enough to make
    the ComboBox list small enough to be manageable.

    The above method is "slicker", but sometimes the management of counting
    characters and moving focus can cause some undesired behavior. A cruder, but
    more reliable method is to use the GotFocus event of the ComboBox to prompt the
    user for a few characters with an InputBox and then afterwards do the same as
    above regarding the RowSource and dropping the list.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     

Share This Page