Hi Guy's this one should be so simple but finding it difficult, may well be my method
I am trying add a text box on my report in the detail section, there may 5 records on the report
Joe has ordered 5 items from stock, 3 items has got the same product number and 2 are a different product number
I have got a field in the stock called Start Qty, i am trying add a text box to display the current stock level based on Product number, if the first 3 products are Product 452996 and the last 2 products are 451664, what is the formula in the text box to show stock level of that product number ?
Header
Name Product No Warehouse Qty
Detail
Joe 452996 (txtProductNo) Control Source =DLookUp("StartQty","tblStock","ProductNo = txtProductNo")
Joe 452996
Joe 452996
Joe 451664
Joe 451664
Warehouse Qty is not returning anything, have i got this all wrong or the formula wrong ?
Kindest