Hello D.A.S.,

Add this code to your UserForm1 code. This will display the first record when the form is displayed.
Private Sub UserForm_Activate()
    SpinButton1.Value = 2
    TextBox7.Value = SpinButton1.Value
    ShowCurrentRecord
End Sub