No Next Record Message

[nerb61 via AccessMonster.com]

How can I get a label to display when the user click "Next" and there is no
Next record? Also how to get a label to display if user has answered all
questions in a survey? Thanks in advance.

 

[John Vinson]

How can I get a label to display when the user click "Next" and there is no
Next record? Also how to get a label to display if user has answered all
questions in a survey? Thanks in advance.

Well, that rather depends on the context. Care to post your code, and
indicate how and where you are doing this???

GUESSING wildly here... you could trap the error message in the Form's
Error event.

John W. Vinson[MVP]

 

[nerb61 via AccessMonster.com]

I have created a survey with a Button that takes the user to the Next
question on a subform. What I want is a label that appears when the user has
reached the end of the questions within an Issue (main form). My main form
holds the Issue - the subform contains a series of Questions related to the
Issue. Once the user completes all the questions contained in an issue - EOF -
the message should appear, informing the user he/she has completed the issue.

All I have now is the code for the Next button:

Private Sub btnNEXTQUESTION_Click()
On Error GoTo Err_btnNEXTQUESTION_Click

DoCmd.GoToRecord , , acNext

Exit_btnNEXTQUESTION_Click:
Exit Sub

Err_btnNEXTQUESTION_Click:
MsgBox Err.Description
Resume Exit_btnNEXTQUESTION_Click

End Sub