Call passing variables

Hi Zrx,

You have a couple of options on how to pass "month", but there is one absolute requirement ... namely, your Main routine needs to be ready to accept it.

You could use any of the following declaration statements for Main:

Please Login or Register  to view this content.

Using "Optional" means that the "calling" routine can (but does not have to) pass "month" to "Main". To use the "optional" option, you would need to re-write Main to work either with or without "month" being passed.

The byRef and byVal determine whether or not Main can change "month". In this case it does not matter because calling Main is the last thing your form does (right?).

The calling statement can look like either of these:

Please Login or Register  to view this content.

Oh ... one other thing ... month must be dimensioned exactly the same in both routines. So, if you use "month As String" in the declaration of Main, then you must use "Dim month As String" in the calling routine.

Hope this helps.

Hi Zrx,

Not completely sure that I follow your logic. If I am reading this correctly, you are launching a form named "novemberstats" from your Main routine, and then you want to change the values in text boxes on that form using code in the Main routine.

If that is correct, then the problem is that you need to give the full reference to these text boxes, as follows:

Please Login or Register  to view this content.

If that does not work, then use this:

Please Login or Register  to view this content.

I can never remember when I need to use "Object" in that command. But, the intellisense (selection boxes that appear when you press the ".") should give you the answer to that.

Hope this helps.

Hello, MSP77079


I got it working with your help! Yes I needed to put the object ahead of the textbox. Did so in code where needd and it has worked thus far.

Thanks for your input.