display messages

[rudy]

I am using a form for data entry that I want to be able to change the
message that appears when I click on a button to process the entry.
The current message that appears is 'you can't go to the specified
record'. Can this be edited or replaced with one that states 'record
is already in database' or something more meaningful.

Thanks,
Rudy

[fredg]

On 18 Jun 2004 10:03:31 -0700, rudy wrote:

I am using a form for data entry that I want to be able to change the
message that appears when I click on a button to process the entry.
The current message that appears is 'you can't go to the specified
record'. Can this be edited or replaced with one that states 'record
is already in database' or something more meaningful.

Thanks,
Rudy

Code the Form's Error Event:
MsgBox "The error# is " & DataErr
Resume acDataErrContinue

open the form and intentionally make the error.

The message box will appear with the error number.

Then re-code the Error event to:
If DataErr = XXXX Then
MsgBox "Your new message here."
Resume acDataErrContinue
Else
MsgBox "Error #: " & DataErr
Resume acDataErrDisplay
End If
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.