Interactive filters

D

Donald Tait

How do I use the values field in a filter so it can produce a dialogue box that allows you select the resources from a drop down menu as opposed to entering it; like standard 'Using Resource...' filter
 
G

Gérard Ducouret

Hello Donald,

Project / Filter for... / More Filters... / New

It's easy to built an interactive filter which presents a text box to the
operator, but not a drop down list . Its possible with VBA programming but
not easy.
In the "Value" field, you don't write the expected value, but any prompt
between quotes such as "Enter the searched value :"?
Don't forget the exclamation point just after the last quote (without any
space).

Gérard Ducouret

Donald Tait said:
How do I use the values field in a filter so it can produce a dialogue box
that allows you select the resources from a drop down menu as opposed to
entering it; like standard 'Using Resource...' filter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top