Filtering subform and locking columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub form that is set to datasheet 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..
 
I don't believe so. One of the problems of using datasheet view is that
you're stuck with the default behaviour of Access.
 
Rob,
I had tried very thing I could think of and was afraid there is no way to do
it..
Thanks
 
Back
Top