List Box Help

[kristi1023]

How would I populate a list box based upon the results of a search string? The search would be based upon matching any part of a string entered by a user into a text box. I would want to search the course name field in a table and I would like to see all matching results in a list box on the same search form. Thanksss!

 

[nabiS2K]

If you want to only search by one word or phrase, I would create a new query for which to bind the list box. I would make the criteria for the field of the query Like "*" & ListBoxName.Value & "*".

Let me know if you need a more complex search.

God Bless
Mike ;-)

 

[kristi1023]

Thank you, Mike -- it works perfectly! Have a great weekend!!

Kristi