Passing Variables creates more problems

[dccjr]

I am trying to pass a variable (strEventReportSQL) from one Sub to another where it is defined as follows:



{Originating Procedure}

Private Sub cboConValue_AfterUpdate()

Dim strEventReportSQL as String
...
strEventReportSQL = "..."

End Sub

{Receiving Procedure}

Private Sub cmdReportPrint_Click(strEventReportSQL as String)

...

End Sub

Am I missing something here. I know this is probably an easy fix, could someone just point me in the right direction?
Thanks.

[JoeM]

You will either need to define it as a Global Variable, or call one Sub Procedure from the other, passing the value at that point.

[orange]

Dave,
It would be better if you included all the code for the procedures. However, let me make some guesses as to what you are doing. And these guesses may be opposite to your intentions..., but they represent the second option in JoeM's response.

If you are calculating a value for strEventReportSQL = "..." in Sub cboConValue_AfterUpdate() and you want to perform/execute procedure Sub cmdReportPrint_Click using the value of strEventReportSQL = "...",then I think you would
have a statement

     Call  cmdReportPrint_Click(strEventReportSQL) 

in your originating procedure , after you have assigned a value to strEventReportSQL

But as I said, I'm guessing at your intent. There is more info here

Note: The colors aren't meant to confuse. The purple represents a variable, and the blue represents procedures.