I'm building a little db for a friend to keep track of her yarn and knitting projects. One thing she asked for was a row counter. I have my field ProjectRowCount. It's number format, default value is 1. I need to add two buttons. One will increase the field value by 1 and the other will decrease it by 1. I've searched google and the forums here and everything comes back with increasing a field value based on a prior record. I need to increment the current field value in the current record. I currently have the increase button with an OnClick event as =[ProjectRowCount]+1, but that doesn't do anything.
Side note... I did find the SpinButton activex control, but it seems like I have to refresh the page after every click.
Suggestions?