Understanding how to pass a value from form to form

[djspod]

Hi,

I'm just learning some VBA.



I have got a text box to recognise the environ user and display on the start screen.
I'm not sure how to store that value as a variable for later use.
I have several uses for this type of scenario, I'm just clued up enough yet on how to set the programming out.
I presume it will be a Global variable but
where do I start.

I have had a mess around but I'm getting lost somewhere.

Any help, an example or a point in the right direction I would be grateful for the help.






Sent from my SM-G935F using Tapatalk

[orange]

See this for more info on TempVars

[pbaldy]

FYI, for your variables to be accessed from anywhere in VBA, they'd have to be declared in a standard module as public:

Public VariableName As String

You've declared them either in a form module or within a sub.

[djspod]

Thanks both for your advice, ill look into the link and create a separate module for setting the variables. (Cheers Pbaldy )

I'm guessing something like:

Public Userdetails as string

Dim Username as string
Dim Location as string

UserName = environ ("Username ")
Etc etc

From a SUB I then call UserDetails or pass in Me.Textbox = UserDetails.value

I presume I'm on the right kind of logic.

Thanks for taking time to reply.





Sent from my SM-G935F using Tapatalk

[pbaldy]

Well, at its simplest you'd declare the variable in a standard module:

Public Userdetails as string

In some procedure:

Userdetails = environ("Username")

then when you need it:

Me.Textbox = UserDetails

The TempVars method orange mentioned is another alternative, and offers the advantage of being able to be used directly in queries or macros (I think, I don't use them). I was simply trying to educate as to why what you were trying wasn't working.

[Micron]

No problem with the suggestions, but I see that you seem to know how to create a class for contact and customer. Why not create a class for user? You could create user class properties such as FName, Lname, EmplNo, Email, LoginId, UsrLevel, etc, etc.

[djspod]

Hi Micron,

Thanks for your reply

I inherited the DB from a YouTube user so I did not create or use the Class files.
I will let look into that to gain more upstanding of Class, Module and SUB Procedures.

And what difference is between using each and what the benefits are.

Thanks for your help

Sent from my SM-G935F using Tapatalk

[orange]

djspod,

Thanks for responding. I had the same question as Micron re class modules.
Good luck with your project.