I have a form with 4 buttons for newest / newer / older /oldest buttons. They mostly navigate properly, but recently, any new records are being treated as the oldest record. VBA is below, (The Resize line is for a separate portion and is working properly.)
Any help as what may be reading newer records as older? I am self-taught in both my Access and VBA knowledge with assists from Google and YouTube, and have no clue where to look next. Thanks all in advance.
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
ReSizeForm Me
Call subEnable
End Sub
Private Sub GoToFirstButton_Click()
DoCmd.GoToRecord , , acFirst
Call subEnable
End Sub
Private Sub GoToNextButton_Click()
DoCmd.GoToRecord , , acPrevious
Call subEnable
End Sub
Private Sub GoToLastButton_Click()
DoCmd.GoToRecord , , acLast
Call subEnable
End Sub
Private Sub GoToPreviousButton_Click()
If Me.NewRecord Then
Else
DoCmd.GoToRecord , , acNext
End If
Call subEnable
End Sub