DoCmd.GoToRecord , , acLast

[Pedro]

Hello everyone
I have this procedure and suddnely it's not working.
I'm not an expert but it was ok.
It's like this :

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acLast
End Sub

And when i open this form, it goes to another record when it's suppose to go
to the last one.
Any ideas? Please help me.
Tks in advance
Pedro

 

[Douglas J. Steele]

Try putting that code into the Load event, rather than the Open event.

The Open event fires before all of the data has been retrieved.

 

[Allen Browne]

You might get a better result by using the form's Load event:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoLast
End If
End Sub

 

[Pedro]

Ok. It's working. Last one :
Now if i would like to go to the highest value of a field and show me all
the record?
It's a numeric one.
ty in advance
Pedro

 

[Allen Browne]

How about sorting the form so the highest value loads first:

Private Sub Form_Load()
Me.OrderBy = "[YourNumericFieldNameHere] DESC"
Me.OrderByOn = True
End Sub