Dynamic query filters, like Excel's Autofilter

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hello,

This is probably easy, but I can't figure out how to apply filters in a
form dynamically.
I have several text fields in the form, but most of the fields have a
limited number of possible values. So I'd like to build my form with a
filter feature that will show a pull-down box for these fields showing
the current possible values, which will be populated respecting the
current filters applied on a form. In other words, it should behave
like the auto-filter feature Excel (when you filter one field, the
available selections on which to filter in the other fields narrows).
But how to do it?

Like I say, it's probably easy....
 
Hi,



Have you try the filter from a FORM view of your data?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top