Pass variable name to another forms

[Thomman]

Hi Friends,
In my multiuser application, I am using my custom login screen. I need to trap the username from the custom login form and save the username in all the tables whenever an addition / modification of records happens. How can I pass the Username variable to another forms in Ms access?

Thanks

[pbaldy]

One common solution is to hide rather than close the login form (set Visible = False). Then you can simply refer to it in other forms or code to get the user:

Forms!FormName.TextboxName

You can also use a global variable and a public function that returns its value.

[Thomman]

Thanks. I already used public variable but it returns only blank!!! Let me try this.. thnx again.

[pbaldy]

No problem; post back if you get stuck.