Hi:
I use the following code to pass a string called Lens Type: from Start New Plate table to the current table
=DLookUp("[Lens Type:]","[Start New Plate]","[Lens Type:]='" & [Lens Type:] & "'")
It works well when the Lens Type: is all letters, but I have one string that contains both letters and numbers (string is MK5 Test). It won't pass this string. It will ignore it or pass a different string that is only letters. What am I doing wrong?
Thanks