Search by Partial Description

[GibFinch]

I am using Access 2000 and have some VB knowledge. I have a table of parts with locations, part numbers, descriptions, and quantities as the fields in that database. How can I include the ability to enter either a partial or full description in a text box and pull up all potential matches from the description field, maybe displaying them in a list form? Any ideas or suggestions would be appreciated. Thanks

 

[lespaul]

to collect the records:

SELECT * FROM tblName WHERE description like "*Word*"

use this query as the source of your list box

Leslie