Parameter query from last step won't carry forward in macro

[DASeb]

Hi Forum, I'm new here.



I'm having an issue with the macro I've built.

The first step pulls data based on a registration date range that needs to be changed monthly. I decided to create a parameter query with two prompts to simplify things.

The next step in the macro use an If Then Else that looks like this:

If DCount("*","Step 2")>0 Then

Message Box "Update Adjudicator Table"
Stop Query

Else

OpenQuery "Step 3"

My problem is that Step 2 uses Step 1 to make the check, but now requires those two date to be filled in. We do not receive the prompt and this breaks the macro.

Is there a way to save the inputs from Step 1 to be used in the If Action?

Thanks

[June7]

Basically, no. The user inputs to popups cannot be 'grabbed' by the code.

Is this a macro or VBA? I use only VBA.

Why open query? Users normally should not interact with tables and queries, only forms and reports.

I NEVER use dynamic parameters in queries, especially not popup input prompts.

I use controls on form for criteria input. Then I use code to reference the controls and pass criteria to form or report.