Hi, I'm not a native English speaker, please sympathize for my poor writing.
Please have a look at my database (in my attachment or you can download from: http://www.mediafire.com/?yq4qqgc6j830qgu )
In form1, I want Text13 show email of the customer. The email can be retrieved from table tbl_Customer
However, I tried to use
Code:
=Dlookup("Email","tbl_Customer","CustomerID="&CustomerID)
but it did not work.
I don't know whether it is a problem in my database or in Dlookup function.
Please help me
Thanks a million.