query / ascending or descending

[Dick7Access]

I have a main form with name, address etc. I have a tabular form off to one side with lessons sent out, with lesson numbers. (1,2,3 etc.) (Master and child fields the same) populated from a joined query 1 to many. I want the oldest lesson at the top of the list, but no matter if I put sort under the lesson number ascending or descending, first lesson (1) is always at the top. What am I doing wrong?

 

[AbsoluteAccess]

What data type is the lesson number in the table. Is it a number or text? Post the sql for your query.

 

[JHB]

You haven't set the Form.OrderBy Property, (and forgot it)?

 

[Dick7Access]

What data type is the lesson number in the table. Is it a number or text? Post the sql for your query.

Thanks for answering. I have tried it both ways, text and number. Right now this is with number Here's th SQL
SELECT tblMain.txtNameL, tblessons.txtLessonNo, tblMain.txtNameF, tblMain.CusKey, tblMain.txtSal, tblMain.txtAdd1, tblMain.txtAdd2, tblMain.txtCity, tblMain.txttate, tblMain.txtZip, tblMain.txtPhone, tblMain.txtEmail, tblMain.tgbSaved, tblMain.txtStartDate, tblMain.txtRef, tblMain.memComments, tblMain.imgFlag, tblessons.txtDateComp, tblessons.LessID, tblessons.txtLessonName, tblessons.txtDateSent
FROM tblMain LEFT JOIN tblessons ON tblMain.CusKey = tblessons.CusKey
ORDER BY tblMain.txtNameL, tblessons.txtLessonNo, tblMain.txtNameF;

 

[Dick7Access]

You haven't set the Form.OrderBy Property, (and forgot it)?

Isn't the form ordered by the query?

 

[JHB]

No, it is a property of the form see below at the picture:

 

[Dick7Access]

Thanks everybody: We have lift off.
Lesson subform: ordered by: tblessons.txtLessonNo DESC