basOrderBy

[deb]

I have a button on a form that I use to sort records within a listbox.
The issue is, the below field is complex.
i.e. IIf([TLNo]="TBD",[TLNo],[TLNoPrefix] & "-" & [TLNo]) AS TL
The portion of the code (response = basOrderby("TL", "asc")) does not
recognize TL

Any suggesions?


The code is...

Private Sub btnTLAsc_Click()
Dim response As Integer
response = basOrderby("TL", "asc")
Me!btnTLDesc.Visible = True
Me!btnTLDesc.Caption = "\/ TL \/"
Me!btnTLDesc.SetFocus
Me!btnTLAsc.Visible = False
Me!List4.SetFocus
End Sub

 

[Maurice]

Have you tried setting the response as a string because you are trying to put
"TL" in a integer variable or is the basOrderby a function that should return
an integer...