Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filtering

Status
Not open for further replies.

djam

Technical User
Nov 15, 2002
223
CA
does anyone know the command to see if the user performed a filter? (when the user right mouse buttons over top of the field and performs a filter)

thanks "so many events, so little time"
 
What are you going to do with the information you receive? This can make a difference on how you capture the events. There is no command to know when a filter is applied. You will need to include a boolean variable in your procedure to know if the filter was applied. Something like,
Dim UserAppliedFilter as Boolean, when the filter is applied UserAppliedFilter = True.

I hope this gets you started.
 
I am creating my own navigation buttons and would like to put a text saying that the current record has been filtered. But I think I found the solution

thanks "so many events, so little time"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top