OrderBy when opening a form

[Elly Woods]

Hi everyone,

I'm trying to have a form sorted in a particular order when it's opened.
When using the "order by" option in the properties sheet, it is sorted the way I want the first time I open the form. However, if I change the order afterwards while using the form (for instance, by right clicking and selecting another sort order), well the next time the form is opened, it is sorted with this new sort order, and not the default one.

So I tried to add the following code :

Private Sub Form_Open()
    Me.OrderBy "employee_name ASC"
    Me.OrderByOn = True
End Sub

Which failed epically. My error message is in French, so I'm not copying it here, but basically it says that I'm not using the right methods for the right events... Does someone have any insight on the matter?

 

[Drunkenneo]

Try

Private Sub Form_Open()
Me.OrderBy="employee_name ASC"
Me.OrderByOn = True
End Sub

 

[Elly Woods]

Thanks for your fast reply, but no it didn't work, same error message.

 

[Drunkenneo]

The OrderBy property "sticks" only when the form was opened in design
view - then form view & a filter/sort applied - then saved.
To fix: open form in design view & clear out the Filter & OrderBy properties.
Save the form. This should remove any filter/sort when the form is
reopened in form view.

 

[Elly Woods]

Yes that is true, but then I do not have my "default" sort order with which I want my form to open ...

 

[Drunkenneo]

Could u able to provide the sample of your mdb, remove confirdential matters before posting

 

[Elly Woods]

Okay, I was absent-minded, my problem was in fact in the very first line of my code :
It should have been this :

Private Sub Form_Open(Cancel As Integer)

And you were right about the missing " = " sign Thanks a lot !