macro running in order

[dumbledown]

Hi,


I have a form with three buttons on it, which all carry out processes using queries and code. These buttons are pressed in order and all work perfectly.
I want to create a button that consolidates these buttons (Button_ALL) - so Button_1 runs, then Button_2, then Button_3.
However, when copying the various components for these buttons sequentially into a new macro - that Button_ALL calls, it runs the 3 buttons together and the results produced are wrong - it hadn't finished running one of the queries for Button_2 before running the macros in Button_3.
How can I get everything to run in order?

I hope that stream of consciousness makes sense?!
Thanks
Hugh

[Evilferret]

Please post code for each of the three buttons. Hard to say without seeing your code.

[dumbledown]

Thanks Evilferret, I guess that would help.
Hew you go:

The macro is:

RunCode getdatalinks()
RunCode combinelinks()
OpenQuery averagelinks,Datasheet,Edit
RunMacro link nodes from model,,
RunMacro results to links,,

The issue is when carrying out the OpenQuery it hasn't finished but still runs the two following macros.

If it helps the query is this:

SELECT newlinks.[On Link] AS link, Avg(newlinks.SumOfCount) AS [Count], Avg(newlinks.[Length (m)]) AS [Length (m)], Avg([SumOfLink Time (s)]/[SumOfCount]) AS [Time (s)], Avg(newlinks.Speed) AS AvgOfSpeed, 1 AS control
FROM newlinks
GROUP BY newlinks.[On Link], 1;

Cheers!