Help with DLookup

[Etoimos]

I want to lookup the value in the Lab fieldof the RunResultData table and return that value based on the combobox DSRExecutionDate on the DSR form where it matches the ExecutionDate in the RunResultData table.

I tried this code, but it is not working:

=DLookUp("Lab","RunResultData","ExecutionDate=" & [DSRExecutionDate])

What am I doing wrong?

[ranman256]

delimiters

strings need quote delimiters
dates use #
numbers don't use them

=DLookUp("Lab","RunResultData","ExecutionDate=#" & DSRExecutionDate & "#"])

also
use brackets for query fields,
form objects just use the object name : txtBox or me.txtBox

[Etoimos]

Thank you. I knew about the # sign, I just forgot And that is good info about the use of brackets.