SubForms/Last Record

[EndersG]

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.

 

[tc3of4]

Type this in your Form_Load Event

DoCmd.GoToRecord , , acLast

This should do it...

tc3of4

 

[Richie]

Can't you just sort the subform desc.