Creating button to prompt custom filter window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm trying to create a button on a form that would prompt the "Custom
Filter" (Text filter ---> Contains) window to show up. I can't find it on
the RunCommand on the Macros, I'm thinking that it has to be done through
visual basic, but I don't have much experience with that. Any ideas?
 
Freddie said:
I'm trying to create a button on a form that would prompt the "Custom
Filter" (Text filter ---> Contains) window to show up.
Click to expand...
I'm probably being dense, but I don't recognise your description of this
window.

How do you cause it to appear via the user interface?
Which version of Access?

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
On Office 2007, on any split form, right clicking the text box bound a
particular field will bring up the filter menu. From the filter menu, going
to "Text Filters", then choosing any of the functions (Contains, Begins with,
Equals, etc..) will bring up a dialog box titled "Custom Filter". Typing in
the criteria and pressing okay will activate the filter. Thanks!
 
Freddie said:
On Office 2007, on any split form, right clicking the text box bound a
particular field will bring up the filter menu.
Click to expand...
Ah. Sorry - I am not familiar with Access 2007 yet.
I don't think that facility exists in earlier versions.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Back
Top