W
Will
I have a form and a subform based on the tables, tblStockTransfer (ID,
TransferNo, TransferDate, WarehouseFrom, WarehouseTo, TransferredBy,
Transferred) and tblStockTransferDetails (StockCode, Quantity, BatchNo) ,one
to many relationship. I have a transfer button on the main form which
actions the transfer but this only does the current selected record in
tblStockTransferDetails. How can I get it to loop through all the records
in the subform of tblStockTransferDetails? and is this the best way of
doing stock transfers?
thanks in advance
TransferNo, TransferDate, WarehouseFrom, WarehouseTo, TransferredBy,
Transferred) and tblStockTransferDetails (StockCode, Quantity, BatchNo) ,one
to many relationship. I have a transfer button on the main form which
actions the transfer but this only does the current selected record in
tblStockTransferDetails. How can I get it to loop through all the records
in the subform of tblStockTransferDetails? and is this the best way of
doing stock transfers?
thanks in advance