G Guest Jul 19, 2005 #1 How can I design a report/form that will be able to generate the next sequential number on this report/form upon printing.
How can I design a report/form that will be able to generate the next sequential number on this report/form upon printing.
A Allen Browne Jul 19, 2005 #2 Dead simple on a report. Just add a text box with properties: Control Source =1 Running Sum Over Group Format General Number If you need to do it in a form, regardless of how the form is sorted or filtered, see: http://www.lebans.com/rownumber.htm
Dead simple on a report. Just add a text box with properties: Control Source =1 Running Sum Over Group Format General Number If you need to do it in a form, regardless of how the form is sorted or filtered, see: http://www.lebans.com/rownumber.htm
