Hi, Please forgive me as I'm a novice with Access. However, I've got a database where I'm trying to subtract the stock field in a 'Product Table' based on the quantity entered for that item in the 'Form'. I've tried a query but keep getting an error with it. Also, I would like the stock to subtract for all records relating to that item that are entered.
Also, I'm trying to ensure that records 1 and 2 on the form have data from the drop down box, product ID etc saved but it comes blank every time I reopen the form. The other thing I would like the form to do is go to a new record which would be 3 in this instance when the form is reopened every time.
Any help would be greatly appreciated.
Please see attached. Thank you, Paddington.