I have this Dlookup syntax and am trying to link the value in a table to the value on a form.
DLookup("[PLU #]", "tblImportedExcelData", "[Criteria] = " & Forms![Customer Details 2]!CustomerName)
But the problem is, for example, the value on the form may be "00000000000051" (without the quote marks obviously). And the value in the table is "51".
In other words the two relate using the right-most characters. They are both number fields.
What would the corrected DLookup syntax be?