How to change OrderBy property of a subform from the main form? (1 Viewer)

[lana]

Hi there,
I have a form with a subform. The recordsource of the subform is a table.
When the user changes the sort order of one of the fields in the subform, this sort order stays until the form is closed.
I need to change this sort order by VBA.
Any ideas?
Thanks a lot

 

[June7]

Set the form's OrderBy and/or OrderByOn properties.

Do you want to remove sort?

Forms!mainformname.subformcontainername.Form.OrderBy = ""

Forms!mainformname.subformcontainername.Form.OrderByOn = False

 

[arnelgp]

you also use DoCmd to remove the Filter:

With DoCmd
    .GoToControl "subFormName"
    .SetOrderBy ""
End With

you can add a Button on the main form the "Clear" the sorting.

 

[lana]

God bless you.
Thanks so much.