Hi All,
I'm facing an issue on Dlookup. Hopefully someone can help me out of this.
I need msgbox B to show up the EID that the dept is QA but it failed. Something to do with "dept = A" but i'm not sure where.Code:A = DLookup("dept", "Logintbl", Me.txtresp) MsgBox (A) << ' Output is QA B = DLookup("EID", "Logintbl", "dept = A") MsgBox (B)
Thank You