Doing a search on VB

[Pete]

Hi I have a problem I have a list of toys in a form,
people can look at the list for by typing part number of
the toy he wants to get information on, or by clicking at
the down arrow and select the part number, but I also
want the user to type the beginning of the part number,
and get all the part numbers for what the user typed. How
can I do that? I appreciate your help.

 

[Larry Linson]

A Combo Box is a Control that does what you want, and one of the options of
the Combo Box Wizard is that it can determine the data that will populate
the Form on which it resides. The "AutoExpand" property is set "True" by
default and handles the scrolling to the first matching item in the list
when an additional character is typed into the Combo Box.

Larry Linson
Microsoft Access MVP