Understanding Functions and their use

[Lesg]

Hi Guys, I am trying to get my head around a module that has function defined:

Public UsrName
Public UsrPass
Public UsrFullName
Public UsrUserID
Public UsrUserLevelID


Function GetUsrName()
    GetUsrName = UsrName
End Function


Function GetUsrPass()
    GetUsrPass = UsrPass
End Function


Function GetUsrFullName()
    GetUsrFullName = UsrFullName
End Function


Function GetUsrUserID()
    GetUsrUserID = UsrUserID
End Function

These values are retrieved from tblUsers which has columns:
UserID
UserName
FullName
Password
UserLevel

If I check for these in the immediate window I can get the results of each function. However, I need to add a funtion the get the userlevelid and have added the following to the functions:

Function GetUsrUserLevelID()
GetUsrUserLevelID = UsrUserLevelID
End Function

However, when I test this, it does not return a value as expected.



Now its been years since I looked at this, so think I am missing something important here, but do not know what, can anyone advise please?

[CJ_London]

have you assigned a value to is as you presumably have for the other variables?

[Lesg]

ok guys, I have figured it out, I have not defined 'UsrUserLevelID' to the column on the login form, so sorted now