dlookup doesn't work can someone help me out...?

[gino]

i am trying to get my dlookup to work to lookup a value based on the form i am placing this dlookup. for example
i have a field called sbcuid and i want my dlookup field to find a record in another table based on that field. here is what i got so far.

=DLookUp("[EMPLOYEE NAME]","[tbl_sbcuid]","sbcuid")

my criteria is incorrect i think and i can't figure out this one.

your help would be greatful. thank you.

 

[Karl K]

Rather than

=DLookUp("[EMPLOYEE NAME]","[tbl_sbcuid]","sbcuid")

try

=DLookUp("[EMPLOYEE NAME]","[tbl_sbcuid]","[Employee ID] = " & [sbcuid])

I am guessing that the last is an ID code, so instead of [Employee ID] use whatever field works there.