How do I override the ‘Drop Changes’ Msgbox

[PRD]

Hello, I created a Tabular Form where each row has a check-box which the user can check if he wants to view the record in detail. I also have two Command Buttons which run Update Queries. One query checks all of the boxes and the other query clears all of the boxes. I also turned off the Warnings for these queries so the user is not prompted with any MsgBoxes when he runs them.


The problem I am having however, is that if the user checks one of the boxes and then tries to run one of the Update Queries a ‘Drop Changes/Save Changes’ MsgBox appears (even though I set the Warnings to ‘No’). So my question is, can I override this Drop Changes Msgbox so it does not appear? Thank you for your time.

 

[vbaInet]

Hello, I created a Tabular Form where each row has a check-box which the user can check if he wants to view the record in detail. I also have two Command Buttons which run Update Queries. One query checks all of the boxes and the other query clears all of the boxes. I also turned off the Warnings for these queries so the user is not prompted with any MsgBoxes when he runs them.

This (i.e. using checkboxes) is not a viable solution in a multi-user environment.

The problem I am having however, is that if the user checks one of the boxes and then tries to run one of the Update Queries a ‘Drop Changes/Save Changes’ MsgBox appears (even though I set the Warnings to ‘No’). So my question is, can I override this Drop Changes Msgbox so it does not appear? Thank you for your time.

That's because you are using bound checkboxes and the record hasn't been saved before the Update Query is run.

 

[PRD]

vbaInet -

Of course, should have thought of that. I will save the record before running the query. Thx.

 

[vbaInet]

No problemo!