Thanks for the replies this seems to work but now I have a further problem.
I've made a button the removes the filter but now if I use the combo's to filter the data, no data is returned, yet if I exit the form and then use the comb's with the same criteria, data is returned...........what gives??
This is very strange I've found that the problem is the button that removes the filter.
If I use the toolbar command to remove the filter/sort all is well, but using the buttton causes there to be no data returned and also causes a "The applyfilter action was canceled" if I use the search button.
The code I'm using for the remove filter button is
Is this what you are trying to accomplish? Enter A, B, or C in the filter txtbox and click the button labeled "Filter" to requery the subform. Click "Remove", sets the filter to Null and requeries the subform.