Increment value with button (1 Viewer)

[tuisb3]

Hi,

So.... I have managed to create myself a database that almost does everything I need it to. Seems stable enough and works well, however there is something tiny I want to do with an inventory form that I have. Why is it the smallest, what should be easiest, things that always trip me up?!!

So I have an Inventory Form, which relates to my Inventory Table. I have a quantity field that hold quantities for the types of Items I have. I want to increment that quantity field by +1 with the click of a button. I create the button, and try to build an expression.... I thought something easy along the lines of =[quantity] + 1 would do it but it seems not. If you can help me do this with either an expression or macro I would really appreciate it.

Any help would be great, and I know already, you don't have to tell me how much of a stupid easy question that is! I don't know myself how I have got this far with this database! But I have and everything else works great!!!

Many thanks in advance for anyone's help!

Thanks

Steve

 

[Minty]

Try me.quantity = me.quantity + 1

 

[tuisb3]

Thanks v much (Sorry for the late reply!)