is there a way to retrieve the active filter on a form via VBA?
+1
A:
You can get the contents of the filter property (immediate window):
?Screen.ActiveForm.Filter
(([FormName].FieldName="a"))
Other possibilities:
sFilter=Me.Filter
sFilter=Forms!FormName.Filter
Remou
2009-09-05 15:29:34
thank you for your help
jim
2009-09-05 20:32:35
You might want to check if .FilterOn is true or false, as a form can have a .Filter property assigned while .FilterOn is false, which means the form will not actually be filtered.
David-W-Fenton
2009-09-06 22:18:29