Expose filter criteria in subform for use in VBA of main form 1

[MrMode]

I have a main form and a subform.

I can 'filter' the data in the subform by using the arrow next to the column heading and selecting the filters I want to apply.

Is it possible to identify what 'filters' have been selected against the column so that it can be used elsewhere in vba code?

 

[MajP]

Dim strFilter As String
Dim frm As Access.Form
Set frm = Me.subformName.Form
strFilter = frm.Filter

Now you will have to look at the result, because you will likely have to do some string manipulation to get rid of the subform reference.

 

[MrMode]

As always, Thank you