I have an app that uses a database to keep reecords on students. I have a cmdAddNew button for adding a new student and cmdEnter button with this code:

Private Sub cmdEnter_Click()
Data1.Refresh
Data1.Recordset.MoveLast
End Sub

The problem is when start from a blank database there is no "last record" for it to go to. The reason I had this code here is because I need it to show the last record entered when I click cmdEnter. How will I do this when I am starting from an empty database?

I hope I explained this well enough any help is greatly appreciated.

JO