How can I change the confirmation message text that appears after running an update or delete query - I'd like it to say something along the lines of 'you are about to archive "X" records' or something.
use a messagebox
docmd.setwarnings false
msgbox ("you are about to archive records",vbquestion)
docmd.runquery "yourqueryname"
docmd.setwarnings true
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.