ordering records in a subform

[JulieD]

Hi all

i have a form called Cohorts, which has a subform called Classes, on this
subform is a 2 paged tabbed control, the first page has a subform on it
called Assignments, the second has one called Students.

When the student choses a Unit in the Classes subform (from a drop down
box), i run code which populates the Assignments subform with the
assignments applicable to that unit - this all works fine, however, when i
add another unit to the cohort (and populate the assignments subform) the
view returns to the first unit not the one i just entered (i guess this is
to do with me using me.requery in the code).

Is there anyway to have the units ordered by record number (ie move to the
last record, not the first).

Thanks
JulieD

 

[JulieD]

solved - just saw Jim Allensworth answer to a similar question.

thanks