DLookup not functioning correctly - any ideas please?

[shabbaranks]

Hi Guys,

Ive got my DLookup looking for a value in a table based on a variable. The variable is returning the correct result but the value which the DLookup is returning based on that value is incorrect although everything looks as it should be - here is a screen grab

http://i.imgur.com/EZ4bZ.jpg

Thanks in advance

[CGM3]

When using a text value as the key in DLookup, you have to bracket that value in quotes. Try something like this:

Dim cQ As String
 
cQ = Chr(34) ' double quote character
 
sGroupID = DLookup("DepGroupID", "UserNames_tbl", "[sUser] = " & cQ & "sUserID" & cQ)

Many people use the multiple quotes method to insert quotes into text literals, but I find this easier to interpret.

[shabbaranks]

Thanks but it still thinks the value in DepGroupID is 0 when as you can see from the screen grab its 3... Very fraustrating