Need to pass one variable to another form, but it's not passing the value.

[TAPS_MikeDion]

Hi everybody,

Even after looking over examples found on the forum I still can't seem to get this super simple thing to work. I'm obviously missing something small.

I have a main userform that has a "GET CLIENT INFO" button which opens a small userform displaying the client information, but I need the main userform to pass the variable ClientNum to the second form.

This is the code in the first form.

Public ClientNum As Long


Private Sub ClientInfoButton_Click()


    ClientInformationForm.Show


End Sub

When the ClientInformationForm opens it doesn't pass the value of ClientNum.

Please help. Thanks!

 

[dmt32]

Hi,
Move your public variable

Public ClientNum As Long

from your userform code page to a STANDARD module

Dave

 

[TAPS_MikeDion]

Knew it was something simple. Thanks Dave!

 

[dmt32]

Knew it was something simple. Thanks Dave!

Most welcome


Dave