Hi:
I am having a hard time getting DLookup to work. I enter =DLookUp("Lens Type",[Start New Plate]) into the control source of a form, because I want to return a Lens type from the Start New Plate table. I get #Name? returned. I've tried changing the brackets and quotation marks, but I still get the same error. What am I missing? As you've guessed, I'm not a programmer, so I guess I'm missing something basic.
Thank you