several links to filtered list each with differenct criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David_GH - 31 Jan 2008 12:50 GMT

Hello- I'd like to be able to create _several_ (hyper)links to _one_ set of
data, with each link providing a different filtered view of the data. The
"AutoFilter" functionality can display the data in the way I'd like to see
it, but needs the filter criterion to be selected from the dropdown manually.
By clicking on the link, I'd like to arrive at the data with the particular
filter associated with the link already applied.
In SQL, it would be like a SELECT * WHERE (criteria)
Sorry if this is a trivial question!
Thanks, and all the best.

Reply to this Message

FinRazel - 06 Feb 2008 20:59 GMT

Instead of using hyperlinks, why not use macros...
"record new macro" while you perform your autofilter. Then, make a button
(forms toolbar), and assign the macro to that button (or simply assign it a
keyboard shortcut, which is an option in the box when you name the macro).
Running the macro should run the filter, and you can then make a separate
macro for each filter of the data.

Signature

Anne Murray

> Hello- I'd like to be able to create _several_ (hyper)links to _one_ set of
> data, with each link providing a different filtered view of the data. The
[quoted text clipped - 5 lines]
> Sorry if this is a trivial question!
> Thanks, and all the best.

Reply to this Message