Sound if can't go to next record

E

Emmy

Is there a way to hear a sound (ding) when you tab off the last record in a
form? If it can't go to the next record, the user wants to hear a sound. This
is the code I have running on change of the field:

Private Sub YNX_Change()
On Error GoTo Err_YNX_Change

DoCmd.RunCommand (acCmdSaveRecord)
DoCmd.GoToRecord , , acNext

Exit_YNX_Change:
Exit Sub

Err_YNX_Change:

Resume Exit_YNX_Change

End Sub

Thanks,
Emmy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go To Next Record 5
Select Text to End of Footnote 9
acNext 3
Last Record Error 3
Repeat Expression using code 3
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Access goto next record for two tables 9
You can't go to the specified record error 1

Top