Macro passing a parameter

[SlowPoke]

I have written a macro that opens a query. This query asks the user to enter a [Parameter]. Once entered the query runs. After query 1 runs I want to open query 2 and using the same [Parameter] entered in query 1 run query 2. Is this possible? I've looked at setting temp variable but it's not obvious to me.

[HiTechCoach]

I would recommend using a form to collect the parameter value.

To reference the open form from you query use:

forms![Your_Form_Name_Here].Your_Control_Name_Here