Thank you all, It works now!!!
I tried both variations in my full database. I had to use this code:
Code:
DoCmd.OpenReport "GDLVSCL1 User Level Access Report", acViewReport, , "[ManagerName]='" & temp & "'", acHidden
DoCmd.OutputTo acOutputReport, "GDLVSCL1 User Level Access Report", acFormatPDF, sFolder & "\" & MyFileName
DoCmd.Close acReport, "GDLVSCL1 User Level Access Report"
While this code did not load the report, the output was the same for each report. It lost the filtering criteria.
Code:
'DoCmd.OpenReport "GDLVSCL1 User Level Access Report", acViewReport, , "[ManagerName]='" & temp & "'"
DoCmd.OutputTo acOutputReport, "GDLVSCL1 User Level Access Report", acFormatPDF, sFolder & "\" & MyFileName
DoCmd.Close acReport, "GDLVSCL1 User Level Access Report"