Automation of Queries

I have a program that is going to be used for an ambulance company. I have with the help of this forum made really good process. I have now come up against a problem that I can't figure out. I have 2 queries that I need to run in the back round when the dispatcher pushes a button. On of the queries is an append query that makes a return record for an existing record and the other query is an update query that changes the properties that allow the append query to work back to false so that it doesn't keep making additional records. I know that this is probably not the best way of going this, however I pretty proud of it, just because I'm teaching myself access as I go. I really need these 2 queries to run together and on the click of the button, however the I can not figure out the macro or VBA needed to do that. I would really be happy if someone could give me an idea where to start.

VBA

DoCmd.OpenQuery ("queryName"), acViewNormal


S-

So if I have 2 queries I can do the same thing but how do I nest them so that they run one right after the other?

DoCmd.OpenQuery ("queryName1"), acViewNormal
DoCmd.OpenQuery ("queryName2"), acViewNormal