I actually know how I would do this, but I think my process would be incredibly long for such a short answer, so I thought I'd bounce it here:
I have a form where it's output recordset goes to a report. If the "Filter by Form" is enabled, then the Me.Filter value is filled and the report receives that and outputs the correct output.
(Thank you mbizup btw).
what I need to do, is take the Filter itself and make it human readible.
For example, the image below:
Shows the filter of an active Form Filter.
This filter goes to the report and looks like that.
What I need to do is make it "Pretty" as human readable and put that on the report to indicate what the report covers.
For example, I would restate this to say:
DOD is between Jan 1, 2000 and Dec 1, 2000 AND the DOD is in July, and the AGE is between 30 and 35.
has anyone done something like this before? and if so I'd like their lessons learned on how to handle it.