Msgbox!

[Floyd Forbes]

I have a Append and Delete query on a form behind a Command button.
How do I create a msgbox canceling the action if I want to? Can I have
the msgbox "Are you sure",yes,no or cancel.

Floyd

 

[fredg]

I have a Append and Delete query on a form behind a Command button.
How do I create a msgbox canceling the action if I want to? Can I have
the msgbox "Are you sure",yes,no or cancel.

Floyd

By default, Access will offer a message with the option of cancelling
the action query.

1) Check Tools + Options + Edit/Find and place a check in the Confirm
Action Queries check box.

2) Check all of your code modules to see if someone has written a
DoCmd.SetWarnings False code line without also writing a
DoCmd.SetWarnings True line afterwards.