Filter using multiple fields

From: Luther (Luther_at_discussions.microsoft.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 06:31:14 -0800

Hi,

I would like to implement a filter on a form (using a command button) where
the situation is like this:

1. the first parameter would ask (or have an input) for a code; this would
come from a series of fields (Source1-Source10) where "03D" for example can
be located in any of these fields.
2. Then I need a subset of that code by state (for example, code 03D in PA)
3. the form need to refresh to ONLY show these records.

Any help would be greatly appreciated.

Thanks.

Loading