Sue,

You are being more helpful then I could have hoped for. Thank you!

What I'm really hoping for is just the ability to assign a key-stroke
to drill them down to the exact location that currently takes 9 menu
selections.

That's not possible. The closest you could get is a macro to bring up the Filter dialog and, frankly, the client can do that themselves just by customizing the toolbar to add the Filter command to it.

This sounds like EXACTLY the kind of solution we are looking for!! You
have already done so much, but if you could offer, or point me to some
instructions on how to do this, I think all will be well.

Also, it's not clear whether "client" is an individual or a company with hundreds of individuals. A VBA macro would be an appropriate solution only for the former.

They have 4 or 5 users, so creating the macro at each work station is
very doable.

Thanks,

Casey