I have a form that opens in datasheet view. The operators like to click on a column heading, then Home, then Filter. They get a list of check boxes with each unique value in the column and check/uncheck the rows they want to include/exclude. Routinely, they do the same thing with a second, third, fourth and more columns. I don't think there is a practical limit.
I recently applied a filter to the form to limit the rows that appear in the initial datasheet view. Now, with the filter, they can click on one column, then Home, then Filter and they get the same check box of values to include/exclude. However, if they go to a second column and do the same thing, they don't get the check boxes. I have used a filter within the RecordSource and I've tried putting the filter in a RecordSource query. In each case I get the same result.
I would like to be able to apply a filter to the form and still let the user pick multiple columns to further filter the datasheet.
I have tried this with Access 2000 and 2007 databases with the same result.