How do you run a Access query with VBA OnClick function? Instead of using a macro, I want to have VB code run the query.
(This is an alternative to my previous problem with the error message.)

Thanks

Funnily enough the button wizard will do it all for you.