Will a "Me.FilterOn=true / false " approach work in your case? I used this on a single form, where the user could modify the column to search in (combobox) and the text or number to search for (textbox)and then press a "Search" button to apply a filter with his criteria.
I'm not sure if it works with subforms, but I don't see any reason not to. I'll try to find the site where I found this idea it is probably better explained there ... --------------------- Good luck (to us all) W.W.
