Filter properties

[Gaetan]

Hello,

I would like to display in a text box the name of the field that is being
filtered and the filter criteria that is being applied. I know this
information is available in the Filter property of the form but the way it
shows (ex.: ((Lookup_cboJobTypeID.Type="Full-Time"))), it needs a complicated
use of the InStr and Left funtions to get to the information.

I was wondering if there was a simpler way to display the information so
that the user knows what Filter is applied to the data he sees.

Thanks in advance!

 

[Douglas J. Steele]

What exactly would you want to display from the sample filter you gave? Just
Lookup_cboJobTypeID.Type="Full-Time"?

=Replace(Replace(Me.Filter, ")", ""), "(", "")

 

[Gaetan]

It's only a workaround of my solution. Like using the InStr and Mid
functions, it won't work with Filter By Form and will not display the proper
filter when the filter is applied by Filter Excluding Selection.

Any other ideas from anyone?

Thanks!