Problem with DLookup - Can anyone see why this isnt working?

[shabbaranks]

Hi Guys,

Ive got a DLookup within my VBA code and I cant for the life of me see why its not refererncing the correct field and returning the right result. As from the screen grab if I use the immediate window to query the variable its not whats in the table

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

Any ideas?

Thanks

 

[JANR]

Well since your variable sUserID is defined as String you must enclose it in quotes.

sGroupID= Dlookup("DepGroupID", "UserNames_tbl", "[sUser]= '" & sUserID & "'")

JR

 

[shabbaranks]

Thanks for that, unfortunatly the sGroupID value returned is still 0 when it should be 3

 

[speakers_86]

It looks like you might be confusing your primary key with the username field. Is sUserID the string or the autonumber? Rather, does me.currentUser = 27 or "simon.schuck"?

 

[shabbaranks]

me.currentuser = simon.schuck although if it was confusing it wouldnt the return value be 27 rather than 0?

Thanks

 

[stopher]

Have you used any lookups in your tables? Specifically, is sUser a lookup?