Please help SQL Syntax

[jordanturner]

I know this is like 'driving off a cliff' as some people have stated, but I really need this to update the quantity in stock to 1.



So here's the SQL

UPDATE tblStock SET tblStock.QuantityInStock = 1
WHERE (((tblStock.StockID)=[Forms]![frmDispatch].[frmDispatchLine].[StockID]));

The problem is that when this query is run from the subtable on the form it constantly asks for the parameter value of "[Forms]![frmDispatch].[frmDispatchLine].[StockID]", so I was just wondering, anyone know how to solve this? Get rid of that annoying pop-up box and actually let it find the StockID from the subform.

Thanks
Jordan T

[maximus]

Ur SQL will be like this:

UPDATE tblStock SET tblStock.QuantityInStock = 1 WHERE tblStock.StockID=[Forms]![Your Form Name Here]![Control on the Form];

An Example:

I have a table Table1 a form Table1 I want to update the Member_Name to Antony for ID_Member=ID_Number on my form Table1
UPDATE Table1 SET Table1.Member_Name = "Antony"
WHERE [Table1].[ID_Number]=[Forms]![Table1]![ID_Number];

[jordanturner]

Hiya, thanks for the quick reply.
But the only problem is that doesn't work either, is it because its taking the parameter value from a subform?

Thanks,
Jordan T

[weekend00]

Please remember the form must be open.

[jordanturner]

UPDATE tblStock SET tblStock.QuantityInStock = 1
WHERE [tblStock].[StockID]=Forms!frmPurchaseOrderBT!frmPurchaseOrderLine.For m.StockID;

Solved it by using that, thanks for the help though.