fix sort code problem (1 Viewer)

[qupe]

hi
i am using this code on click with button and it work well

DoCmd.ApplyFilter , "status='seen'"
DoCmd.SetOrderBy "ldate ASC"
DoCmd.GoToRecord acDataForm, Me.Name, acLast

but when i use it with form on load the filter and go to the last row does not work but the sort work so why ??


I appreciate any help

 

[sneuberg]

I tried to replicate you problem in the attached database and in this case it seems to work in the form load event. Could you upload your database. Maybe we can see what's different.

 

[missinglinq]

I can't get it to work at all! It bombs on

DoCmd.SetOrderBy "ldate ASC"

and, in point of fact, Access can't find any reference to SetOrderBy!

This does what you want, though, if I understand your need correctly:

Private Sub Form_Load()
  DoCmd.ApplyFilter , "status='seen'"
  Me.Form.FilterOn = True
  Me.Form.OrderBy = "[ldate] ASC"
  Me.Form.OrderByOn = True
  DoCmd.GoToRecord acDataForm, Me.Name, acLast
End Sub

Linq ;0)>

 

[sneuberg]

@missingling Interesting. It appears DoCmd.SetOrderBy is only good in Access 2010 and later

Your code does exactly what the OPs code does on my Access 2013 system.

 

[missinglinq]

Curiouser and curiouser! I hadn't heard of any Methods like this being added.

Wonder what version the OP is using, and if he/she used one version where it worked and another where it didn't?

Linq ;0)>