Sort By is not working, Please help!!!

[dreman]

I have a form using several tab Controls
One of tab Control is used to display All data using a tabular subform.
In this Tab control I want to allow the user to sort by LastName, City, State...
I wrote this routine described below, But it is not working.

Please advise,
Thank you.
Dré

Private SortBy_Click()
Select Case Me!SortBy
Case 1
Me.OrderBy = ClientNo
Case 2
Me.OrderBy = LastName
Case 3
Me.OrderBy = City
Case 4
Me.OrderBy = State
End Select
Me.OrderByOn = True
Me.Requery
Me.Refresh
End Sub

 

[jebry]

Hi!

Is SortBy on the main form's Tab or on the subform?



Jeff Bridgham
bridgham@purdue.edu

 

[dreman]

Jebry:
Hmmm very good question,
I do not know the difference But this is what I have.
Tab1: (CLient Edit)
Tab2: (View tables)
Sort By: o ClientNo o FirstName o City
(The sort is within Tab2 but outside the Subform)
Subform (Tabular listing via wizard to display tabular column of all data)
Tab3: ....
Tab4: ...
Thank you for the response.
Please advise,
Dré