Delete Query Button on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a delete query button on a form.

The button wizard does not list my delete query.

I ve also aked this on the forms page... sorry for reading it twice.
 
Hi accesscrazy - Create a macro and attach the macro to the button (from the
Misc section.) The macro only needs 1 line - OpenQuery using your delete
query.
 
That marco worked for me for my delete button in a form, but after I click
it, it puts a #delete in my record row(s). To get rid of it I have to close
the form and re-open it. Please help!

Access Frustrated
 
On Fri, 6 Nov 2009 13:36:01 -0800, Access Frustrated <Access
That marco worked for me for my delete button in a form, but after I click
it, it puts a #delete in my record row(s). To get rid of it I have to close
the form and re-open it. Please help!

Access Frustrated
Click to expand...

Requery the form as the last step of the macro.
 
Back
Top