Filtering subform and locking columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a sub form that is set to data*** view the and the user, uses a
popup menu with the standard Filter By Selection, Filter For and Excluding
Selection to apply filter to the subform.

The problem is if the user has applied filters to several columns when they
use remove filter, it will remove all the filter that have been applied.
I have noticed that when you click on the header of the column in the
subform it will highlight the entire column, is there a way to apply to the
on click function of the column that is highlighted to lock so the filter
remove will not apply to the columns that have been highlighted?

Thanks you..

.

Quantcast