Hello,

I have a delete query in my database which I would like to run from a command button on a switchboard. When I use the command button wizard, it does not show delete queries in the menu of available queries. If I create a command button manually I will need VBA code for the event procedure.

Can someone give me an appropriate code for running a delete query with a command button?

Thanks

Create a macro that opens the delete query.
Use the command button to run the macro.

Thank you. Some things are so simple, but you don't see them.

Ron