DLookup function

[primerov]

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 ?

 

[PaulBricker]

It probably doesn't say Enter Parameter Value exactly. What does it say exactly. That may tell us what value it is bombing on.

Paul

 

[chrissie1]

is productid the name of the textbox or is it the name of a field in the table "What a wonderfull world" - Louis armstrong

 

[Dalain]

if the productid is a Number Type field field and located on your form the code should be

=DLookup("grade", "OutVa", "productid = " & me.productid)

if the productid is a Text Type Field field on you form the code should be

=DLookup("grade", "OutVa", "productid = """ & me.productid & """&quot

Pierre