going to last record in subsubform

  • Thread starter Thread starter Werner Rau
  • Start date Start date
W

Werner Rau

Hi,

I have a form with a subform and a subsubform
I try to write VBA code to go to the last record of the subsubform of the
last record of the subform of each record, using the oncurrent event of the
form. It does not seem to work. I use Access 2000
Can somebody help?

Tnx, Werner
 
If you are just trying to always show the last record maybe changing the
sort of the data in the subform would be easiest. If you are using a table
as the source for the subform, change it to a query of that table, and set
the sort accordingly.

Tony Vrolyk
 
The records in the subform and the subsubform are ordered by date and I
would like the order to stay ascending, but showing the most recent...
So I am trying to write VBA code
 
Your request still sounds a bit contradictory to me but you could try
this...

Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
End Sub
 
Back
Top