Hi,
This is my first post on here, so here goes.
I was handed a database that has been assigning a field "Item Number" by manually typing in a number (2009xxxx, ie, 20090233). On the table, that is the name of the actual field(with the space).
What I want to do is this:
Add a button. The button does the following:
1. Fills in the "Item Number" field for that entry using the NEXT sequential number, prefixed by 4 digit year).
2. Disables itself once that "Item Number" is filled by clicking it.
I'm an amateur at this, not a professional programmer. I can figure out where to insert code, however, what to type is beyond me.
Any help is appreciated.
Thank you in advance.