Newbie. How do I use DLookup with a variable please?

[graffiti]

Hi.

Another very simple one for the font of all knowledge. I have the following code which works perfectly:

 
'Return the ID of the matching UserName
    varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = 'test1'")

However, I obviously don't want to hardcode the 'test1' into the expression. The following variations on using a variable fail:

 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = " & varUserName)
 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = varUserName")
 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = 'varUserName'")

varUserName is a string variable which has been earlier retrieved from a text box and I know it has the correct content by using the debug step through system and watching the variable(s).



How should this be phrased correctly please? Yes, I am working through this by trial and error. Thanks.

Mike.

[Toyman]

Hi.

Another very simple one for the font of all knowledge. I have the following code which works perfectly:

 
'Return the ID of the matching UserName
    varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = 'test1'")

However, I obviously don't want to hardcode the 'test1' into the expression. The following variations on using a variable fail:

 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = " & varUserName)
 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = varUserName")
 
varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = 'varUserName'")

varUserName is a string variable which has been earlier retrieved from a text box and I know it has the correct content by using the debug step through system and watching the variable(s).

How should this be phrased correctly please? Yes, I am working through this by trial and error. Thanks.

Mike.

varUserID = DLookup("[ID]", "tblDBUsers", "[UserName] = '" & varUserName & "'")

[graffiti]

I knew it was simple, when you know how. Note to self: research syntax more.

Thanks very much.

Mike.