Re: How to get matching values with list box and dropdown property?

From: Ron Weiner (
Date: 07/25/04

  • Next message: Paul Saah: "Find data in table"
    Date: Sun, 25 Jul 2021 09:37:42 -0400

    List Boxed do NOT have a DropDown Property. Sounds like you want a list box
    whose row source is controled by a text box. All you need to do is change
    the list box row source using the value in the text box. For example:

    lstYourListBox.RowSource = "Select YourColumm From YourTable Where
    YourColumn Like '*" & txtYourTextBox.Value & "*' Order By YourColumn;"

    Should give the results you want.

    Ron W
    "Jack Darsa" <> wrote in message
    > Hello,
    > I want to define a list box with dropdown property, but i don't want to
    > limit the choices the the first character only ,but to any consecutive
    > characters typed by the user. For example:
    > if the list contains
    > abcdef
    > abdeg
    > abchi
    > bcdef
    > The outcome should be:
    > input value shown from the list (rows)
    > b 1,2,3,4
    > bc 1,3,4
    > bcd 1,4
    > In this example the list is not limited only to the first characters , but
    > to any string with the typed characters.
    > Anybody can help me ?
    > Jack

  • Next message: Paul Saah: "Find data in table"