In the ControlSource of a text box in a report i have tried the following DLookup function:
'=DLookup("grade", "OutVa", "productid = " & productid)
With the above function i wanted to pull the field "grade" from the query "OutVa" having the same ProductID number.The productID number exists both in the query and the report.
However on opening the report i receive the message "Enter parameter value"
Can somebody help me ?