A prior problem I had has morphed into a dlookup problem....
It seems I am having trouble with the syntax for the criteria portion of the Dlookup command. I want to compare the value of the field called pr_ppProjectId found in the query called EMRevenueForecast to a field called pr_ppProjectId found in the table called Forecasts (this table is the form's record source) and present a value called pr_ppClientName from the same query.
Originally posted by Balinor
Is this dlookup in a form, query, or report?
Try this one:
=DLookUp("pr_ppClientName","EMRevenueForecast","[pr_ppProjectId]='" & [pr_ppProjectID] & "'")
Also, just for kicks and giggle, try removing the = at the beginning
Let me know,
The dlookup is in a form. The form refers to both a query (for screening purposes) and a table (for editing purposes). The table is the record source for the form so the user can edit directly to the table.
The first solution gets me the #Error and removing the '=' gets me #Name?.