Search results

As for everyone else, thanks for helping me! I understand that I shouldn't be doing stock updates like this on access. However, this is gonna get me a high mark for my assignment lol.

It works!! Thank you for actually taking the time to help me so much and not just advising me not to do it! You are the best, much love <3

I'm now getting this error message:

I'm still getting the parameter problem :/ the sql code definitely still works when I'm inputting it through the parameter boxes, just not running automatically still.

"Take into consideration factors such as placing orders, managing stock as well as updating data such as new customers etc. (dependent on your clients business)" The way I have it running so far is that the customer orders through the 'Orders Form', this contains a combobox to enter a customer's...

Sorry about that, still new to this. Basically everything works when I use the parameters, I just want it to run automatically without them. Not really sure how to use TempVars lol, could you explain a bit more?

I understand that it's not ideal haha. It's for an assignment, and part of the brief is to keep track and update stock. Just wanted to know if there was a way to achieve this in a continuous subform without it asking for parameters. Thanks

I have a stock management system and I want it so when you put through an order on a form it automatically updates the stock level. I have the correct update query and I have added a macro to the form so when you click off of the quantity field it should update the stock level. However, it keeps...