im using data envi. ,how can u have restriction in a query for example. select employee from emp_tbl where emp_id = ' " & text1 & " ' from visual . and show it in data report. another thing, how can u pass value from visuaBasic to a data report Richtextbox. Ty more powerl