MS Access VBA Sub with update query not presenting message
Posted on 2010-09-09
My MS Access app has a VBA sub that has runs an update query. The Sub is run as a result of clicking on a button on a form. When the query is run directly, it presents the message, if applicable, "Microsoft Office Access can't update all of the records in the update query". But when the query is run via clicking on the button, the message is not displayed.
I added On Error GoTo Err_PresentMessage at the top of the code and Err_PresentMessage:
MsgBox Err.Number & Err.Description
at the bottom, but the message still does not appear.
I would like to present all messages to the user and eventually intercept them with more detail about how to correct, etc. How can I get the messages to appear?