have you tried debug.printing your filter statement to see if it's constructing it correctly
have you set the FILTER ON LOAD to YES
is your REGION field a text value or the PK (numeric) indicating the region?
Is this code from some other location, I haven't ever tried to apply filters to a report, I prefer have dynamic criteria on the query driving the report instead, but I do not know if the DOCMD.OUTPUTTO will work without the report name supplied (you currently have "" and I don't know if that will work) have you tried:
DoCmd.OutputTo acOutputReport, , acFormatPDF, mypath & MyFileName
what I'm reading is that you have to leave the report name blank (not a blank string)
I ran a test where I modified your code slightly:
Code:
Dim db As Database
Dim rst As Recordset
Dim sExportPath
On Error GoTo ERRHANDLER
Set db = CurrentDb
Set rst = db.OpenRecordset("tblemployees")
Do While rst.EOF <> True
Debug.Print rst("ee_id")
DoCmd.OpenReport "rptTest", acViewReport, , "[EE_ID] = '" & rst("ee_id") & "'"
sExportPath = CurrentProject.Path & "\" & rst("ee_id") & ".pdf"
DoCmd.OutputTo acOutputReport, , acFormatPDF, sExportPath
DoCmd.Close acReport, "rptTest", acSaveNo
rst.MoveNext
Loop
rst.Close
Set db = Nothing
Exit Sub
ERRHANDLER:
Debug.Print Err.Number & " " & Err.Description
and it exported everything properly filtered.