I have yet to come across a need for a form or report to be based on a table, and if you used a query instead, this would be far simpler. I'd be interested to know why you believe you cannot use a query, which by its very nature can be made to fully replicate any table. In addition it would give you the result you want because you'd filter out records based on your value in the first place.
You might find that a format event (detail.format?) would work but it's not something I can imagine trying in place of a query for the report recordsource so I don't know for sure.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.