By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,483 Members | 1,585 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,483 IT Pros & Developers. It's quick & easy.

Remove orderline from subform when returning order

P: n/a
Hi!

In my database (ms access 2000) I have a routine for returning orders.
User can check a checkbox in the frmOrderdetails (a subform of
frmOrders) next to each orderline, and click a button. The orderline is
being returned and I've managed to return Amount (of items) back to
tblAmountsInStock, so that this table is updated.

By this:

strOlines = "INSERT INTO tblAmountsInStock
(ItemID,AmountIn,OurDate,Returned) " _
& "SELECT ItemID,AmountIn,now(),Returned " _
& "FROM tblOrderdetails " _
& "WHERE Returned = true AND ItemID = " &
Forms!frmOrdrers!frmOrderdetails!ItemID

CurrentDb.Execute strOlines

However, I'd like to remove the orderline chosen in frmOrderdetails
which has been chosen for the return-order, even if it is nr two or
three in the row.

Any suggestions?

Me.Name

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.