Cancelling a button click

  • Thread starter Thread starter weircolin
  • Start date Start date
W

weircolin

Hi

I have a button that when I click it, it resets a column. Access
automatically brings up a popup asking if I'm sure. If I say no I get
a runtime error. Is there a line of code I could add to the following
to stop this from happening?

Private Sub Command24_Click()
DoCmd.RunSQL "Update [Newsletter Database] Set Requirement = Null;"
End Sub

Thanks

Colin
 
Colin,

Are you sure you have the right group? This group is for ASP.NET questions
(web based stuff)... you seem to be asking about Access applications.

Also, it might help if you posted the details of the specific runtime
error... there's lots and lots of them :)

Regards,

Rob MacFadyen
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 2501 2
Create a yes no message on a command button on click 0
Excel Providing user message when RED X clicked & properly closing application. 2
Button click & filtering a GridView 2
How to cancel Finish button click in wizard control? 5
button click event problem 1
Ajax popup control extender-onclick button event 0
A button that only works on second click - why? 2

Back
Top