Recommend not having dynamic parameters in query. Apply filter criteria to report when it is opened. Example:
DoCmd.OpenReport "reportName", , , "UserID=" & Me.tbxUser & " And WeekNumber=" & Me.tbxWeek
If you prefer, can probably use TempVars in place of the textbox references, but I have never used TempVars.
Here is a tutorial showing how to dynamically build filter criteria in VBA http://allenbrowne.com/ser-62.html
Also, set sort criteria in report design, not in query. Any sorting or grouping set in report design will override query sort.
And again, why 'plug in' TempVars for display on report? Should be able to pull values from report RecordSource.