Hello all,
I have a command button that's used to trigger a macro that opens an "insert" query. However, it's possible for the user to click the button, then hit the cancel option on the default warning that appears when executing this type of query.
I like the warning behavior, so I don't just want to force execution of the query and suppress warning dialogs--I think the end users in this particular case will actually appreciate the "Warning: this will append X rows of data" both for the information and the positive confirmation that something has happened.
However, if they hit cancel rather than OK, is there a way to trigger an event from the cancellation? Thanks in advance for any assistance.
I have a command button that's used to trigger a macro that opens an "insert" query. However, it's possible for the user to click the button, then hit the cancel option on the default warning that appears when executing this type of query.
I like the warning behavior, so I don't just want to force execution of the query and suppress warning dialogs--I think the end users in this particular case will actually appreciate the "Warning: this will append X rows of data" both for the information and the positive confirmation that something has happened.
However, if they hit cancel rather than OK, is there a way to trigger an event from the cancellation? Thanks in advance for any assistance.