Are you opening the report from the Navigation Pane or from a button? From the Navigation Pane, you'd need to have the report based upon a Query that limits to the records you want, for instance selecting only due dates less than or equal to 5 days from now and only tasks not marked as completed.

If opening from a button, just add the Where Condition to docmd.openReport.

docmd.openReport "MyReport", acViewPreview,, "DueDate <= #" & Date + 5 & "# AND TaskComplete = False"

OK, that sounds easy enough.  Thank you. I will probably open from a Navigation Pane.

Or an even simpler no-code method is to make a query with the criteria you want and base the report on that query. For example, include only records where the task is not complete and the due date is within whatever range you consider "due."

If you later want the user to pick a date range, put Start Date and End Date boxes on a form and have the query use those form values as criteria. Donald's VBA approach is perfect if you're opening the report from a button, but for opening it from the Navigation Pane, the query is the easiest route.

Value From a Form