How do I run an append query from a button like northwind sw/brd

G

Guest

I am trying to run an append query the same way Northwind opens forms. The
Northwind switchboard just uses =OpenForms("Suppliers") in the "On Click"
event. It seems like =OpenQuery("QueryName") would work, but it doesn't.
Thanks for the help.
 
G

Guest

On the on click event select code and in the code write

Docmd.OpenQuery "QueryName"
 

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

help with code to open form with openargs 1
Append Query from Button 3
Run Append Query from ControlButton on Form 3
Append Query 2
Append Query Re-run 3
Controlling flow of actions 2
Running append query on recordset 6
How to run an append Query in VBA on a recordset 2

Top