Get Table sort and filter properties (VBA)

[wongburger]

Hello!

I am working on a vba script that will evaluate how a table's columns are currently filtered and sorted, [run some code which requires the sorting and filtering to be cleared], and then return the table to how it was previously sorted and/or filtered.

I know how to sort and filter a table to a desired state using VBA but i dont know how to read and store the current settings from a table to be re-applied at a later point in the code.

Thank you in advance!

[ranman256]

the filter / sort is on the form:

me.filter= "[state]='" & cboState & "'"
me.filterOn = true

msgbox me.filteron

and the table property:

dim tdf as tabledef
set tdf = currentdb.tabledefs("tMyTAble")

msgbox tdf.filter