Can any one guide me for the method/approch to implement searching-access-list-boxes-data-as-you-type-in-ms-access-forms with "mutiple items to select in list box"
Example to elaborate: I have a primary_skills list box field. Now I tried to choose multiple items ("DB2" and "SQL server" to select) where as I was able search first one and selected the check box of db2 and later when I change search txt i get error pointing debug at me.refresh line of my code in "on change" event. Error:Runtime error '3058': Index or Primary key can not contain a NULLvalue.
Note:current list box has 100+ items
Here is MY previous thread for more details: Searching Access List Boxes data as-you-type in MS access forms