attach a delete query to a command button?

H

hayley

i know how to create a delete query, and i have done this and it works. i
also know how to attach a query to a command button so that the query is
automatically run when you click on the button, but when i try to attach the
delete query to the command button in the same way as any other query , it
does'nt work?!?!

please help!!

thanx x
 
A

Allen Browne

Create a macro that uses the RunSQL action to run your SQL statement.

The macro can use SetWarnings to turn off the confirmation dialog if you
wish, but remember to SetWarnings back on again.
 
Top