Can you add a sound to a Null entry error message?

[etislost]

I finally have a form set so that it will not accept a Null entry in a Combobox. It shows the standard Access error message when you try to move to another record if you have a Null value in the cbo. Is there a way to change that message? Is there a way to get a sound file stored on the server to play when that error message pops up?

Thanks,
Steve P.

 

[luceze]

Try this site.

http://www.mvps.org/access/api/api0011.htm

HTH,
Eric

 

[etislost]

Great. Just one problem though...where do I put the code? I'd like to get it to play the sound file when the error for Null entry pops up. If not possible, is there a way to change the text of the Null entry error message?

Strugglin as a beginner,
Steve P.