Order by with sub forms

[BillA]

I've got nested subforms; a Main form with a subform that contains a subform.
The main form has Employee data, the first subform contains project(s)
information and each project has comment(s) in a subform.
I'm trying to figure out how I get the Projects to show the most recent
projects.
I'd like to also have the comments show the most recent (max date?) comment.
I assume I would use the "Order by" data property... but it's not working
for me.
I assume I would use the following fields:
Projects - ProjectNumber (combination date & sequential number).
Comments - CommentDate.
I think this should be easier than I'm experiencing.
Any advice would be appreciated.
Bill

 

[BillA]

My brain is functioning again...
I found the Me.OrderByOn and updated as necessary. I've got it Working the
way I wanted it.