[AccessD] filtering a subform

I thought of that too, but changing the linking field seems to work for the
example. 

Susan H. 

You can't alter the subform's recordsource *after it opens*, which I don't
find odd, given the nature and intent of subforms.  What you *can* do
dynamically is alter the subform object, however, so another alternative
would be to have 3 subforms to display the 3 result sets and simply swap out
the subform on the button click.