How do I surpress the 'FilterOn' pop-up?

[AlCamp]

Billy,
I take it you mean that you can filter by using the right click
"shortcut" menu, and selecting a filter function.
If you want to do the same by code, check out "Filter Property" in HELP.
It's very straight forward. You tell Access what the filter is, and then
you turn it On/Off as needed.
ex.
Me.Filter = "Country = 'USA'"
Me.FilterOn = True

hth
AlCamp

 

[billyboy2]

The 'Filter' property/coding works fine if I first enter a filter value into
a 'FilterOn' pop-up dialog box.
Is there a way to surpress the pop-up and still activate the 'FilterOn'
and make the 'Filter' work?
OR, let me re-phrase my question:
Is there a way to automatically use a new 'Filter' value whenever I
select a new record without the 'FilterOn' pop-up?

Thanks for your expert suggestion.
- Billy Boy

 

[billyboy2]

Thank you so very much! It worked fine like you suggested.
Billy Boy.