How do I increment a record with a button on a form?

[zy0n1c]

I have a simple inventory system i'm working on. I have a simple "quantity" field. How can I allow my employees to enter a number in a blank text box and hit the "add quantity" or "remove quantity" button when doing inventory receiving? Like...if I even knew what this function was called I might be able to figure it out on my own. How do I add a number input to a single "cell" (record) in my table my form is associated with?

[pbaldy]

Me.Quantity = Me.Quantity + 1

[zy0n1c]

Could you explain in more detail, please? So the button runs a macro that runs that code? Where do I put that code?

[pbaldy]

That is VBA code that would go behind the add button.

http://www.baldyweb.com/FirstVBA.htm

[zy0n1c]

Wow, that was a lot easier than I thought. I still don't understand WHY it works, but it does work for what I need. Thank you.

[pbaldy]

No problem. The code basically says "set the quantity field equal to whatever it is now plus one".