Me.OrderByOn = True - Not working ??

[Wayne-I-M]

Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub

 

[fredg]

Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub

You're missing a space between [Surname] and Desc

Try:
Me.OrderBy = "[Surname] DESC"

 

[Wayne-I-M]

Fredg

You are a genius

Thank you

--
Wayne
Manchester, England.

Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub

You're missing a space between [Surname] and Desc

Try:
Me.OrderBy = "[Surname] DESC"