ordering records in a subform

  • Thread starter Thread starter JulieD
  • Start date Start date
J

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
 
Back
Top