Selecting Records on a Split Form Based on "Or" Criteria

[bfryxell]

I have been working on a database that involves chamber music groups with the potential for each group to have up to two coaches. I set up a split form with the groups table showing on top and a list box of coaches on the bottom. Is there a good way using macros, V.B., etc. to set it up so that the top part will show groups where either Coach1 or Coach2 is equal to the selection in the list box?

For example, let's say that Joe Schmo is a coach for two groups. For one group, he is Coach1 and for another group he is Coach2. Upon selecting Joe Schmo in the list box, I would want both groups that he coaches to show up.

Thanks in advance!

[June7]

So you have the datasheet part on top?

The listbox is UNBOUND and used for purpose of inputting filter criteria?

Review:

Uses dynamic parameter query
http://www.datapigtechnologies.com/f...tomfilter.html

My preferred method
http://www.allenbrowne.com/ser-62.html

[bfryxell]

Thank you for replying! I ended up setting something up using a continuous form.