[AccessD] Increment Number for each Record on Form

http://www.lebans.com/rownumber.htm

William

----- Original Message ----- 
From: "Boyd, Mark Thomas (US - Philadelphia)" <mboyd at deloitte.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, December 21, 2005 2:32 PM
Subject: [AccessD] Increment Number for each Record on Form


>I need to display an incremental number for each record on a continuous
> form, without creating a bound AutoNumber field.
> I've seen this done on reports, but cannot replicate it on my form.  I
> believe all that is needed is a textbox, with the control source set to
> "=1".  Again, on a report this seems to work fine.  On my form, the
> textbox displays "1" in each record.
>
> Any ideas?
> Thanks.
>
> Mark Boyd
> Senior Consultant
> Enterprise Risk Services
> Deloitte & Touche LLP
>
> Tel: +1 215 405 5576
> mboyd at deloitte.com
> www.deloitte.com <http://www.deloitte.com/>
>
>
> This message (including any attachments) contains confidential information 
> intended for a specific individual and purpose, and is protected by law. 
> If you are not the intended recipient, you should delete this message.
>
>
> Any disclosure, copying, or distribution of this message, or the taking of 
> any action based on it, is strictly prohibited. [v.E.1]
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>