Pass a variable to the report. In the recordsource for the report set your where criteria = ?. Then in the "query parameters" box for the "data" tab in the properties for the report, put an explicit reference to the criteria on the form.
Eg if you are sorting a company table for just the company currently displayed on a form you could do something like:
WHERE company.company_id = ?