CODEWITHSUNDEEP
ms-accessvba
jim
jim

Reputation: 27426

Access 2003 VBA Get Active filter?

is there a way to retrieve the active filter on a form via VBA?

Upvotes: 1

Views: 4261

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

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

Upvotes: 2

Related Questions