Delete Query Button on a form

[accesscrazy]

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.

 

[Kernow Girl]

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.

 

[accesscrazy]

Best advice.... simple easy to do and works!!!!!!!!

Thank you Kernow Girl.

 

[Access Frustrated]

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

 

[John W. Vinson]

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

Requery the form as the last step of the macro.