How to open a Form to the Last Record

[djclinton15]

If I wanted to open a Form (or Subform) to a, 'New Record' I would use this code:




Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub


If I wanted to open a Form (or Subform) to the 'Last Record' wouldn't the code be:


Private Sub Form_Load()
DoCmd.GoToRecord , , acLastRec
End Sub


It's not working. I would greatly appreciate any suggestions. Thanks in advanced!

[alansidman]

Look at this link

https://bytes.com/topic/access/answe...rm-last-record

[djclinton15]

Thanks a lot