Creating a Form which numbers itself with each new record

brendawidner · Apr 30th, 2002, 08:41 AM

I want to create a purchase order and be able to have it number itself with each new transaction.
I.E.--Start with #1, enter information, save and then click a button for the next number to appear in the No. ______________ box.
How do I do this?

Von Pookie · Apr 30th, 2002, 09:00 AM

The following posts may give you some help:

http://www.mrexcel.com/board/viewtop...ic=874&forum=2
http://www.mrexcel.com/board/viewtop...ic=131&forum=2
http://www.mrexcel.com/board/viewtop...c=5063&forum=2

Hope this helps,

_________________
Kristy

"There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

[ This Message was edited by: Von Pookie on 2002-04-30 08:00 ]

Apr 30th, 2002, 09:00 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	The following posts may give you some help: http://www.mrexcel.com/board/viewtop...ic=874&forum=2 http://www.mrexcel.com/board/viewtop...ic=131&forum=2 http://www.mrexcel.com/board/viewtop...c=5063&forum=2 Hope this helps, _________________ Kristy "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer [ This Message was edited by: Von Pookie on 2002-04-30 08:00 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 08:41 AM	#1
brendawidner New Member Join Date: Apr 2002 Posts: 8	I want to create a purchase order and be able to have it number itself with each new transaction. I.E.--Start with #1, enter information, save and then click a button for the next number to appear in the No. ______________ box. How do I do this?