Button Wizard Bug??

[crosmill]

I'm trying to run a delete query from a button, but when I use the wizard to create the event, it doesn't show me the delete querys as an option, just the select queries.

It's not a problem I can just script it, but I was wandering whether anyone else had come across this, is it a bug, or is it just not an option?

I've run delete queries like this before, but I can't remember if I've scripted them or used the wizard.

Any thoughts.....

 

[The_Doc_Man]

The wizard doesn't show you anything for which you would need to run an EXECUTE. But that's OK. Let the wizard build your skeleton based on any SELECT query. Then go back into the code. Remove the DoCmd.OpenQuery completely. Replace it with

CurrentDB.QueryDefs("your delete-query name goes here").Execute