Sort not working

[Egg 'n' Bacon]

HI.

I've added some sort buttons to a form, but I'm not sure why they're not working.

Could someone have a look please & tell me where I'm going wrong.

TIA

Database8.zip

[HansV]

You're setting OrderBy to a field and then setting OrderBy to True - that makes no sense. After setting OrderBy to a field, you must set OrderByOn to True to make the sort order active. There is no need to set OrderByOn to False first.

Code: Select all

Private Sub FirstNameUp_Click()
    Me.OrderBy = "FirstName"
    Me.OrderByOn = True
End Sub

etc.

[Egg 'n' Bacon]

Doh!

That's what comes from rushing.

Thank you muchly.

I had put in the 'OrderByOn to False' to negate any other sort that had been put on the recordset.