Sort button in the Form Header

[trident]

I have created a button in the Form header, it was working but not quite.



When I press the button above, it will sort the list but it will not include the last 3 lines. I tried it ascending and descending on all the columns and the same result comes out, the last 3 lines are not included in the sorting.

below is the VBA created On Click under event procedure. Please help. Thank you.

Private Sub Command47_Click()
If Me.OrderBy Like "*DESC" Then
Me.OrderBy = "TenderID"
Else
Me.OrderBy = "TenderID DESC"
End If
Me.OrderByOn = True
End Sub

Also attached is the screen shot of the report.

[CJ_London]

what happens if you right click on the tenderid column (any row of data) and sort from there? Does it sort correctly?

[trident]

When you right click any part of the row of data, this is what it shows,



It does not sort the data, but shows a box as shown above.