Mike- This is easy to do in a report - simply add a text box with Control Source set to =1 and the Running Sum property set to Over Group or Over All. If you actually want to generate and save this number in each new record, you'll have to write some code in the form's Before Update event to find the previous high number for the current sales order, add 1, and save it. If these records have some sort of sequence, you can also generate the number by using a subquery to count the number of rows that have a lower sequence.
If that doesn't help, need more details... John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, October 31, 2005 9:32 AM To: ms_access@yahoogroups.com Subject: [ms_access] AutoNumber for Subform Hi All, I have a subform that I would like to display a "record Counter" on beginning with "1". This number doesn't need to be stored anywhere, it's strictly for informational purposes. The scenario is this: The main form has fields for "Sales Order Number" and "Ship Date". These are linked to the subform which contains an additional field called "Pallet ID". The purpose is to have a counter that would show on the subform so that the shipping folks can keep track of how many pallets they are loading on a truck. The subform is in "Grid" view. Any suggestions??? Idea's??? As always, any help is greatly appreciated :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
