Form Filter issue (1 Viewer)

[prabhus]

Hi,

I use Me.Filter & Me.Filteron to filter the data from the table to display in the form, i used this in On Open event & This is working fine.
But in the filtered form when the user right click and filter some value and unfilter the search (in the bottom of the form next to search (Navigation Button) ) then this shows all the data from the table i.e its not taking the on open filter condition.

How to fix this.

 

[pr2-eugin]

Why would it? You are "de"filtering, this includes all filters.

 

[prabhus]

Why would it? You are "de"filtering, this includes all filters.

Well, not me, but when the users do this, i have a risk that they may update the wrong data. so i want to control this, is it possible

 

[pr2-eugin]

Lock user filtering. Set the Allow Filter property to be False, as soon as you set the filter.