you need to implement the pattern matching in the search code using LIKE operator and call the same in the textbox_change( ) event.
for search code
1. connect to database.
2. open the record set.
3. then implement the search using dynamic SQL and display the result in some control like list box or grid.
Comment