Your select statment is wrong.
If empno is a text field then it shoud be;
"SELECT * FROM employee WHERE empno like '" & TextBox1.Text & "%'"
And if empno is a numeric field you can not use 'Like' to filter the records.
|
Results 1 to 2 of 2
Thread: Filtering RecordsHybrid View
|
Click Here to Expand Forum to Full Width |