I wanted to have the users log in and keep the username and id available for other forms and procedures. I went to my main Module (not tied to a form) and declared two public variables. I then created a small sub to initialize the values of these variables. The sub was called when the main menu loaded.

It does not work. I've tried everything I can think of and the variables do not retain their values. What am I doing wrong. Is there another way to do this without referring back to a main form or passing values with OpenArgs?

Here is my code:
Public p_strUserName As String
[in the declaration area of a separate module]
Public p_intUserID As Integer

[below in that same module]
Public Sub InitializePublicVariables()
    p_strUserName = "Bill"
    p_intUserID = 5
End Sub

---

Reply from Richard Rost:

You have to use the keyword GLOBAL in your variable declaration.

Global Username As String

The PUBLIC keyword is something you use in a FORM module so that other forms can use that value. If you want a variable to exist outside of, and to be used by, all objects in the database, you have to declare it in a standard module and use the Global keyword.