"select distinct prtynm from vprtywrk where prtynm = '" & textbox1.text & "'"
- you can put where clause in this part referencing the field that like what i did. prtynm is the field in your database and textbox1 is the textbox that you are using to filter the records that will be shown on your datagrid
you can also try this one
"select distinct prtynm from vprtywrk where prtynm like '%" & textbox1.text & "%'"
Regards,
John