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