cmdNext Error Msg not working

[SeadooRider]

I have the following code for a next record button in an access form that won't bring up msgbox after last record is reached.

On Error goTo_cmdNext_click
DoCmd.GoToRecord, , acNext
Exit_cmdNext_click
Exit Sub
Err_cmdNext_click
Msgbox "No more records etc.", , "Last record"
Resume Exit_cmdNext_click
End Sub
 

Please assist,
Jason

[Seth Schrock]

The error is in the second line of your code. It needs to be

On Error GoTo Err_cmdNext_Click

You are also missing a few colons. Try the following code

On Error GoTo Err_cmdNext_click
 
DoCmd.GoToRecord, , acNext
 
Exit_cmdNext_click:
    Exit Sub
 
Err_cmdNext_click:
    Msgbox "No more records etc.", , "Last record"
    Resume Exit_cmdNext_click
End Sub

[SeadooRider]

The only difference I see is the capital C in click. that was a typo, the actual code does have a capital C but it still doesn't work.
If I'm missing something completely here please dummy it down for me.

[Seth Schrock]

Line numbers are referencing my code.
Line 1: You have goTo_cmdNext_click. You can't have the GoTo connected to the line you want to go to. Also, the name of the line is actually Err_cmdNext_click. So I put GoTo Err_cmdNext_click.

Lines 5 and 8. You have to have colons at the end of the name. Otherwise, Access thinks that it is either a variable or a procedure that you are trying to call.

I'm guessing (almost sure) that you don't have option explicit set. See Require Variable Declaration on why you need it and how to make it set automatically.