I have a button on a form which takes the records from a filter and prints them on a report. I have added this code to the report to reflect the filter criteria:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Let Me.txtFilter = Forms("[My Report Name]"
.Filter
End Sub
Which works great, but it needs to be a little "cleaner" by not including the name of the query, etc. All I want to see is what the selection was in "filter by selection" to neatly include in the report header. Any ideas?
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Let Me.txtFilter = Forms("[My Report Name]"
.FilterEnd Sub
Which works great, but it needs to be a little "cleaner" by not including the name of the query, etc. All I want to see is what the selection was in "filter by selection" to neatly include in the report header. Any ideas?