A
andywalker
Hi,
I have two forms And i want to be able to pass variables from one for
to another. for example in form 1:
CurrentUser = TxtUser.value
then in form 2 i want to be able to use this variable eg
LblUser.Caption = CurrentUser
Where do i declare this variable in Vba and how?
I have tried a global variable in a standard module but this didn
work.
any help would be appreciated
thank
I have two forms And i want to be able to pass variables from one for
to another. for example in form 1:
CurrentUser = TxtUser.value
then in form 2 i want to be able to use this variable eg
LblUser.Caption = CurrentUser
Where do i declare this variable in Vba and how?
I have tried a global variable in a standard module but this didn
work.
any help would be appreciated
thank