Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Unanswered: How to programmatically set the selection in a list box

    I have a list box that displays a list of items such as 1999-010, 2004-099...

    What if I wanted a text box where the user could type in 1999 or 1999-0 or 1999-010... and the listbox would select the first item that matched the criteria. ie. simulate mouse click on that item in the list box?

    Is my question clear? I think I confused myself...

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    I figured out a way. I just defined a recordset
    SELECT feild FROM table WHERE field Is Like textbox
    if not .eof or not .bof then
    I goto the first record
    then I assign the value of the listbox = value of first record in recordset
    endif

    Is there a better way?

Posting Permissions

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