I have a mainform/subform. I would like to move through each records using the main form's built-in navigation buttons (i.e., first, previous, next and last). However, I want the records inside the subform to begin with the last record instead of the first. So for example, instead of starting at 1 of 4 of the subform, I am starting at 4 of 4 of the subform. I'm sure you must use the FormCurrent event of the main form but am not sure how. Can anyone out there help me?

Thanks.

Type this in your Form_Load Event

DoCmd.GoToRecord , , acLast

This should do it...

tc3of4

Can't you just sort the subform desc.