Display Last Record

  • Thread starter Thread starter ESERSEN
  • Start date Start date
E

ESERSEN

I have been searching posts for 3 hours trying to find a way to display
the last record in a sub form on a tab-controlled page. I have tried
many 'suggestions' that appeared to have worked for others but will not
work for me. Can someone please help? I have a main form 'MyMain'
and a sub form 'MySub'. The sub form is located on a tab-controlled
page. When I select a main record, I want to be able to click on the
tab and see the subform display the last record. I have tried
DoCmd.GoToRecord, , acLast. This does not work. I have tried
..bookmarks and could not get that to work. Can someone PLEASE work
with me to get this to work? It can't be that hard.

Thanks :)
 
Try this:
Me.MySub.Requery 'if you need this
Me.MySub.Form.Recordset.MoveLast
 
Back
Top