Dual Field Parameter Filter

[Steve Scott]

I have created a custom filter that asks me to enter a project code value and
then searches two seperate text columns for the given value. Only issue is
that it asks me to enter the value twice is there an easy way I can get it to
only ask me once?

 

[John]

I have created a custom filter that asks me to enter a project code value and
then searches two seperate text columns for the given value. Only issue is
that it asks me to enter the value twice is there an easy way I can get it to
only ask me once?

Steve,
Short of using VBA, I can't think of a way to do it using a filter
without having to enter the code value twice.

John
Project MVP