Export problem pls read...

[joelxez]

Dear experts,

I have a code below which call the empID in the Reports and match the empID of the current Form to export the current empID of the form, what happen is only the first record was display...pls. help me?
____________________________________________________________
Dim stDocName As String

stDocName = "EmployeeReports"

DoCmd.OutputTo acReport, stDocName, acFormatRTF, "C:\Employee.rtf", True, "WHERE [empID]= & Me![EmpID]"

____________________________________________________________

joelxez@yahoo.com

Joel,

 

[galar]

I've overcomed this problem when I first opened the Report with the specifyed "where condition" and then executed the OutputTo method. After I close the report.