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.