Query

[josros60]

I have form to calculate qty. on hand it works giving me the quantity on hand but every time i open the form ask for parameter value, how can i fix this?

here it's the expression:

OnHand: OnHand([pkProductID],Forms!FrmStockTakes!StockTakeDate)

and here it's the sql view:

SELECT tblProducts.ProductName, OnHand([pkProductID],Forms!FrmStockTakes!StockTakeDate) AS OnHand, tblProducts.pkProductID, tblProducts.UNIT, tblProducts.QuantityPerUnit, tblProducts.UnitPrice
FROM tblProducts;

Thank you

 

[SydneyGeek]

I assume that you get asked for Forms!FrmStockTakes!StockTakeDate each time?

If so, that is most likely because the form is not open. Another option is that you have a typo in a field name.

If it's the open form issue, create a button on FrmStockTakes that opens the query, and run it from there.

Denis