Search drop down box

[steve111]

HI ,

I have a table with over 10000 records and it is growing
the part numbers all begin with

1/

then either a.p.c and s
ie 1/a, 1/p these are followed by numbers
1/a264-001 0r 1/p264-001
the a.b.c.and s represent the name of the company the 264 represents the family of items ie 264 could represent any part of a car wheel

I have a drop down box that highlights all the part numbers in a form
is it possible to search a drop box with wildcards. then I can just look up the 264 items or any other number

thanks
steve

 

[CJ_London]

is it possible to search a drop box with wildcards

No - but you can change the rowsource to limit the records to display

 

[Tark221]

If you know the part number, if you start typing into the drop down box it will try to find it if it exists.