Hello All,
I Have a remove button when selected it deletes an itemline of the hire order.
When a item has been removed, the stock should update on the item table.
Currently i could remove the item and update the stock but cannot get it to match for the same item within the item table.
so if any item had been removed it updates the first item in the item table
This is what i am using
Set rsremove = CurrentDb.OpenR ecordset("SELEC T * FROM itemline WHERE hireno = " & lsttransaction & ";")
Set rsitem = CurrentDb.OpenR ecordset("item" )
This is picking the right item from the listbox and deletes it on the form and within the itemline table but does not update the stocklevels in the item table
any ideas???
I Have a remove button when selected it deletes an itemline of the hire order.
When a item has been removed, the stock should update on the item table.
Currently i could remove the item and update the stock but cannot get it to match for the same item within the item table.
so if any item had been removed it updates the first item in the item table
This is what i am using
Set rsremove = CurrentDb.OpenR ecordset("SELEC T * FROM itemline WHERE hireno = " & lsttransaction & ";")
Set rsitem = CurrentDb.OpenR ecordset("item" )
This is picking the right item from the listbox and deletes it on the form and within the itemline table but does not update the stocklevels in the item table
any ideas???
Comment