Combo box search a list box

T

twen

I want to use a combo box as a search box for a list box located right below
it but to allow users to type in a name and go directly to it. I was just
wondering if anyone knew if or how I could select an item from a combo box
that would select the given value in the list box? Is it even possible? Reply
if it was unclear or if you have an answer or suggestion.
 
V

Vsn

Bisides I do not see the point since a list box will nearly do the same as a
combo box, you will need a bit of code like this in the after update event,
providing your comb and list box have the same record set:-

sub combo1 after update
list1 = combo1
list1.requery
end sub

Hope that helps

Ludovic
 
Top