Partial word search in Combobox

[DirkS]

Hi all,

I'm trying to make a catalog using a form in Access.

Currently it is working in a way that when I type the complete name off the product exactly the same as it is in my database, it displays the right information. However, I would also like that if I only type a part of the name of a product, it will also pop up, preferably together with all products with the same name. E.g. if I have shoes sized 40 up until 46, I now have to type 'Shoe size 45' in order to retrieve the info, however I would like it to be possible to just type 'Shoe' and get an overview of all products containing this term in its name.

Thanks in advance!

[Homegrownandy]

change the search criteria to something like this:

Like "*" & [Forms]![Form_Name]![Search_TXT] & "*" Or Is Null

*bold is the parts you need to change.

There is also a function that can update resuslts as you type if you were interested:

http://allenbrowne.com/AppFindAsUTypeCode.html