I created data report,but i want to access it from vbforms by using select statement

[ksraju]

i created data report for all employees information.In report i am getting all the employees information.actually i want particular employee info... so that i want to acces report from form by placing text box in form and entering empid after that only i want to call the report for particular employee.
give info regarding that.

[buddu]

hi ksraju

Private Sub Command1_Click()
DataEnvironment1.rsCommand1.Open ("select * from Employees
Where EmployeeID=2")
DataReport1.Show
End Sub

Cheers