Greetings. I have the following code that I tailored from one of your classes. It works great except it doesn't Order the titles in ASC order. The "Title" Field it is supposed to order by is actually a combo box. Is this why it is not sorting correctly, and if so, is there a way around it?

Private Sub Form_Current()

On Error Resume Next
Dim MySQL As String

If LessonName = "*" Then
  MySQL = "Select * FROM LessonNameT Order by Title"
Else
  MySQL = "Select * From AssignmentsT WHERE LessonID=" & LessonID & " Order by Title"
End If
  Forms!ChooseRdgsF!AssignF.Form.RecordSource = MySQL
End Sub

---

Reply from Alex Hedley:

I'm not sure what you mean by
"The "Title" Field it is supposed to order by is actually a combo box."

Is there a Title Field in both the [LessonNameT] and [AssignmentsT]?