This question is kind of a tag on to a question I had a couple days ago in a different 'gub group' here on the Accessforums.net.
My question this time, is in regards to a paragraph I read in the book "Microsoft Access 2010 for Dummies", on page 111 under a 'tip' it reads:
"If you want to get fancy, create a macro that automatically fills in the next invoice number in sequence"
I'm assuming this macro would look at the value of the previous record and add a one to it. Being new to access I'm not sure how you do this. Anybody here on the forums be able to help me on this?
I don't want to use a AutoNumber field as I might need (a) to modify value or (b) need to skip numbers.
thanks for reading.