Hello Juan,

Can you type the formula for the DLookup and post it on the forum? Also, is there a WHERE condition with a number field? For example, DLookup("OrderDate","CustomerT","Customer=" & Bob). This will not work because Bob is not a number. Whereas you can use  quotation marks in nonnumeric WHERE Conditions, I have found it works a lot better to use the the ID field. So try DLookup("OrderDate","CustomerT","CustomerID=" CustomerID). If you are already using this structure, then there are other problems. If you have't resolved the problem yet, try posting the DLookup formula on the forum.