Change value of table in Access by pressing a button on a form

[cassandragubler@gmail.com]

Hi, I'm pretty new to Access. I really only have about a month using it. I have a split form where I have created a button. Upon pushing the button I would like the "Qty" field of that highlighted record to be updated to something like "Qty = [Qty] - [Qty Pulled]". The "Qty Pulled" is a text box where I enter the amount that I want to have taken out. I've tried using various "Set Variable" options on the macro, I've tried conditional formatting on record and nothing seems to be working. I already have the button attached to a macro so that's why I'm trying to go that route instead of using a code builder but if you think it'd be easier to do it another way then I could try that. I would have to change some additional stuff though.

Any ideas would be greatly appreciated and thank you so much in advance.

[pbaldy]

Most of us would recommend against trying to save the quantity on hand. We'd calculate it on the fly from transactions. An oft-posted link:

http://allenbrowne.com/AppInventory.html

[cassandragubler@gmail.com]

That link helped and it's working now. Thank you so much!

[pbaldy]

Happy to help!