Delete query button?

[jpalk]

Hello,

I'm just wondering if someone can explain why I cannot create a button on a form to run a delete query?



I've tried to do this, but when I am using the control wizard to create the button, it does not list any of my delete queries as options. So I'm just curious as to why this is.

Additionally, I'm curious if I can edit the code in VBA to do it anyways?

Thanks for your insight, I'm new to this & appreciate the help in my learning! I haven't been able to locate anything useful about this very easily.

Jpalk

[weekend00]

Sure you can "edit the code in VBA to do it anyways".

to run a query, please put following code in click event of the button
private sub command123_click()
docmd.runsql "queryName"
end sub

[jpalk]

Cool, thanks so much!