Hello,

I'm trying to set a global variable from a sql string, unsure on how to do it.

My module is:

Code:
Module AgentIDNumber

    Dim AgentIDNumber As Integer

    Sub Main()
        AgentIDNumber = 

    End Sub

End Module
I want the AgentIDNumber to come from the Users table and AgentID Column.

Not sure whats the best way, I want it to be set when a specific user logs in.

E.g

Andrew Smith puts in his username and password, presses logon and it sets the global variable to whatever his AgentID is in the sql table.