Run Update query on each line of continuous form

[aron.ridgway]

Hi There, i have set up an update query. is there a way of looping through a continuous form record set and running the update on each line?

 

[aron.ridgway]

i have the following update query, that i want to run on each record in the recordset, when the OrderdetailFK from the recordset equals the OrderdetailFK in a table?

UPDATE (tblOrderDetail INNER JOIN tblQtySoFarTEMP ON tblOrderDetail.OrderDetailPK = tblQtySoFarTEMP.OrderDetailPK) LEFT JOIN tblReceiveDetail ON tblOrderDetail.OrderDetailPK = tblReceiveDetail.OrderDetailFK SET tblReceiveDetail.Qty = [tblQtySoFarTEMP].[RemainingQty]
WHERE (((tblReceiveDetail.ReceiveDetailPK) In ([forms]![frmReceive]![sfrmReceiveDetailEntry].[Form]![ReceiveDetailPK])));

 

[pr2-eugin]

Concatenation in VBA !