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:
What am I doing wrong?Code:=DLookUp("Lab","RunResultData","ExecutionDate=" & [DSRExecutionDate])