When I click on a button in my form, I get the below error msg.
The command or action 'SaveRecord' isn't available now.
How can I make the msg read "Must click the edit button first" instead of
current msg?
Thanks
You can use code to replace the system message with your own.
Here's how you can find the correct error and show your own message
for any of the form level errors.
First code the Form's Error event:
MsgBox "Error#: " & DataErr ' Display the error number
Response = acDataErrDisplay ' Display Default message
Then open the form and intentionally make that error.
The message box will display the error number and the default error
message.
Next, go back to the error event and change that code to:
If DataErr = XXXX Then
Response = acDataErrContinue ' Don't display the default
message
MsgBox "Present your own message here."
Else
MsgBox "Error#: " & DataErr
Response = acDataErrDisplay ' Display Default message
End If
where XXXX is the error number.
