Hi,
Not wanting to step on anyone toes, i would like to suggest that when building a search component that needs to update as soon as you type Avoid to:
1. Use key/up/down/press whenever possible.
2. Sql strings
3. IFs and Cases for criteria/parameters*
The reason:
1
Key press/down won't...