Mr Allan Browns "Find as you type example"

[Guest]

reference http://allenbrowne.com/AppFindAsUType.html

I read a post and found this interesting how a user types in characters in a
search form and the combo box displays the results. However Can this code be
modified to populate a list box also with the wildcard like statement. Thanks

 

[Allen Browne]

The code generates a filter string, and applies it to a form. List boxes
don't a Filter, but a filter is really just the WHERE clause of a query, so
you could do something similar if you built the whole query statement and
assigned it to the RowSource of the list box.

At the simplest level, the code to assign the RowSource looks like this:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

To try to use that technique with the "Find As You Type" example would need
a significant re-write though. The code in the utility is very simple to
implement - just one line on any form. But the behind-the-scenes stuff goes
to considerable length to cover all bases so that it can handle any form in
any recent version of Access.