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...
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