vba code to cancel or continue operation

[kevinh2320]

I have a button on a form that triggers a macro that runs a query to append data into a table. I want to have a message box to appear when a user clicks the button giving them the option to either proceed and append the records or, cancel the action and not append the records.

So far I'm just using the built in macro options within Access. Any suggestions on how to accomplish the above task using the built in macro options or by writing VBA code would be greatly appreciated.

Thanks KH

 

[VBE313]

How about

Dim proceed As Integer
proceed = MsgBox("Do you want to proceed?", vbQuestion + vbYesNo)
  If proceed = vbYes Then
    'Insert Query Code
  Else
    'Insert False Code
  End If
End Sub