stuck ....that simple
and any suggestions / comments / criticisms will be more than welcome in advance
Code:
Sub ShowUserRosterMultipleUsers()
Dim intUserCnt As Integer
Dim str_BE_FileName As String
Dim str_BE_lookup As String
'get the name of the current backend file
str_BE_FileName = Right(linklocation("tbeFixtureTypeDetails"), 255)
'count number of users who have are logged into the file;
'a visual check of the table where a list active users is stored shows only one record and the file name matches
intUserCnt = DCount("User_name", "tblUserFile_Log", "FileLink_BE_proj = "" & str_BE_FileName & """)
'yet the count is 0
'<<<--THAT IS WHERE I'M STUCK -->>>
' since there is only 1 record in the table, so lets take look at it's value
str_BE_lookup = DLookup("[FileLink_BE_proj]", "tblUserFile_Log")
' and check if it equals the file i am checking for
MsgBox str_BE_FileName = str_BE_lookup
' it does "true"
End Sub