View Single Post
Old 09-09-2019, 07:50 AM   #10
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,488
Thanks: 50
Thanked 1,038 Times in 1,019 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Macro problem - Re querying

Quote:
Originally Posted by Ceebee86 View Post
Hi DBguy,

I have been scouring the internet on how to identify what filter is in place, but I am coming up empty handed so far.

What Option should I be selecting to determine if a Filter is in place?

Where and on what event would you recommend using this?
Hi. As for the event, I would suggest the AfterUpdate event of the radio button or Option Group. I don't use macros much, so using VBA, I would check for a Filter with something like:
Code:
strFilter = Me.Filter
or
Code:
If Me.Filter<>"" Then
Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote