Customize Message Box On Command

[jpkeller55]

I have very little experience with messaging in Access. I have code written that will change the status of a record from Active to Inactive when the user clicks on the command button on the form. The user will think they are deleting the record as they will be taken away from the form when they click on the button but will really only be updating the status indicator. Because I am using an UPDATE command, the standard Access message box that pops up is:



"You are about to update 1 row(s)"
"Once you click Yes, you can't use the Undo command to reverse the changes."
"Are you sure you want to update these records?"

and then it gives the options to click on YES or NO.

How can I change this error message so that it says something like:
"You are about to delete this record...blah, blah, blah"
"Are you sure you want to delete this record?"

and then present the YES or No option buttons?

Thanks much!

[pbaldy]

Use a Yes/No message box, with If/Then code; if Yes then execute your SQL, either using SetWarnings before and after or using CurrentDb.Execute instead of RunSQL. More info on all in VBA help.

[ajetrumpet]

you can create your own form that serves as a universal message box. that's what I do. if the message is an action query warning from the program itself, you can either turn the messages off in the options or use the currentdb().execute command instead of using docmd.runsql

[jpkeller55]

Thanks Adam and Paul. I will give this a shot.