Turn off filter and sort on loading

[Guest]

I want to turn off filter and sort on loading a form (i.e. just use the sort
in the underlying query). What code do I use to disable filter and sort?

 

[Stefan Hoffmann]

hi Sam,

I want to turn off filter and sort on loading a form (i.e. just use the sort
in the underlying query). What code do I use to disable filter and sort?

Ues the On Load event of your form:

Me.FilterOn = False
Me.OrderByOn = False

mfG
--> stefan <--

 

[Guest]

You don't need any code. Just set the forms filter and filteron properties
in design view. If you later want to filter while the form is open, that is
okay.