Lookup function (Access 2000)

In a report i have 2 fields calclulating the sales in different ways, but i want to have a third, an unbound control looking up for the figure in a table called products and in a field called stock. Since this figure is static i want to look up the table depending on the number of the product in the list of the products that the report shows.The name of my unbound control is Text32, and the fields on the reports are as following

ProdictID ProductsOnConsigmnet ProductsSold Stock

i want to find out what is the figure of the stock in the table products. The table products has a field caled productid which i use in my report. Heres is an example:
On Cosnginment Sold Stock

1. Round Apple 40 20

I have tried the following code but Access does not accept it:

DLookup("stock", "products", "productid = " & Me.productid)
I do not know shall i refer to the Productid, or to the name of my unbound control which is Text32.

Re: Lookup function (Access 2000)

Thank you very much for your kind reply. With me ProductID is numeric.To my regret however i still
cannot display my DLookup on the report.Acces denies me that. I have put the following in the control source of Text32:
=DLookup("stock", "products", "productid = " & productid)
I wonder where my mistake me be. I do indeed have a table products, and a field called stock.
Is it possible that i have some other mistakes?Something with my report?Or may be i just cannot manage to enter the code in the right way.Anyway i will be grateful for any comments.I am very sorry that i cannot manage to do the coding properly