Referencing a Global Variable

[bunji]

I am trying to use a global variable in a dlookup but get an error when i try and run the form

Here is the code:

VUserID is my Global Variable.

Private Sub Form_Open(Cancel As Integer)

Dim UsersName As String

Me.WelcomeBox = UsersName

UsersName = DLookup("[Name]", "tbl Password", "[username] = vUserID")

End Sub

Any Ideas

 

[KenHigg]

UsersName = DLookup("[Name]", "tbl Password", "[username] = '" & vUserID & "'")

???