Running three queries as one

T

Tony Williams

I have a form that has three command buttons. On clicking each command
button a query is run. They are all update queries and must be run in a
specific order as one query is dependent on the other queries running first.
I want to combine all these queries so that they will run in the right order
by clicking a menu item on the switchboard and then showing a message that
they have all run.
I know how to amend the switchboard but how do I combine the queries to get
them to run in the right order as one routine.
Thanks
Tony
 
J

jlepack

Create a macro that runs the three queries in order. Run that macro
from your switchboard.

Cheers!
 

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

Combine Duplicates in Query 0
Messages after running queries 4
Running Multiple Append Queries through a command button. 0
Access Switchboard error message 1
Exporting query w/ parameter to Excel 1
Display Query Results on top of a Form 1
eliminate message from append query to eliminate duplicate record. 1
Message box when query finished 1

Top