run a delete query from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to be able to run a delete query from a button on a form? When
I try to do this using a wizard, it does not list the delete query in the
query list?

TIA
 
Is it possible to be able to run a delete query from a button on a form? When
I try to do this using a wizard, it does not list the delete query in the
query list?

TIA
Click to expand...

The syntax to run any query is:

DoCmd.OpenQuery "QueryName"

If you use the wizard, enter any query name.
Then open the button's code window and change the name to that of the
actual delete query name.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Delete query problem 0
Parameter Query Won't Run 0
Delete Query Button on a form 4
run delete query from command button 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Run multiple queries from control button on split form 1
Delete Query Help 2

Back
Top