Find a value in a column in a table

[Khalil Handal]

Hi to all,
A text value is stored in: NTUserLogin = TempVars("UserLogin").
I need to find if this value exists in table tblMembers in column (field) NTUserId (This field is a text field)

I tried the following: DLookup("NTUserId", "tblMembers", Nz(NTUserLogin))



I am having an error in the third part of the DLookup.
Any help is really appreciated

Khalil

[ranman256]

try:

DLookup("NTUserId", "tblMembers", "[NTUserId]='" & TempVars("UserLogin") & "'")

[Khalil Handal]

Thank you very much

[Micron]

• Insert the formula in “=IF(ISERROR(VLOOKUP(A2,$B$2:$B$1001,1,FALSE)),FAL SE,TRUE)” the formula bar.

The question relates to Access, not Excel, no?