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

  • Thread starter Thread starter AlCamp
  • Start date Start date
A

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
 
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
 
Back
Top