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

Stock

P: 49
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.OpenRecordset("SELECT * FROM itemline WHERE hireno = " & lsttransaction & ";")

Set rsitem = CurrentDb.OpenRecordset("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???
Mar 5 '08 #1
Share this Question
Share on Google+
1 Reply


P: 49
Hi I have resolved this issue now it is picking up the hireline with no problem.....



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.OpenRecordset("SELECT * FROM itemline WHERE hireno = " & lsttransaction & ";")

Set rsitem = CurrentDb.OpenRecordset("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???
Mar 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.