list boxes

[Guest]

I am trying to make a list box that is based on a query. That query uses a
text field to determine what records to return. I can make this work for with
an after update event.

What I would like to do is have the list box respond after each key stroke
similar to a combo box. I prefer a list box, but if I have to use a combo box
I can.

 

[Larry Linson]

I am trying to make a list box that is based on a query. That query uses a
text field to determine what records to return. I can make this work for
with
an after update event.

What I would like to do is have the list box respond after each key stroke
similar to a combo box. I prefer a list box, but if I have to use a combo
box
I can.

You can replicate the Combo Box AutoExpand functionality with a Text Box and
a List Box. (You can't do it with just a List Box, because you can't type
into it, only scroll and select.) If you happen to have the Access Cookbook
by Getz, et al, you'll find an example there. On the other hand, it seems a
good deal of work to do in order to duplicate something that already exists
(and which also hides its dropdown list when it is not being used, thus
saving screen real estate).

Larry Linson
Microsoft Access MVP