aut0-numbering row in continuous form

siamandm
BronzeLounger
Posts: 1232
Joined: 01 May 2016, 09:58

aut0-numbering row in continuous form

Post by siamandm »

Hi

i would like to have an auto numbering for the rows inside continues sub form how I do this, please?
regards

User avatar
HansV
Administrator
Posts: 78515
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: aut0-numbering row in continuous form

Post by HansV »

Should the numbering be stored in the corresponding table, or is it for display purposes only?
Best wishes,
Hans

siamandm
BronzeLounger
Posts: 1232
Joined: 01 May 2016, 09:58

Re: aut0-numbering row in continuous form

Post by siamandm »

HansV wrote:Should the numbering be stored in the corresponding table, or is it for display purposes only?

its only for display and print/
Regards

User avatar
HansV
Administrator
Posts: 78515
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: aut0-numbering row in continuous form

Post by HansV »

Row numbering on a form is not easy, it requires relatively complex code, and it is prone to break when the user adds or removes records, so I would advise against using it.

Row numbering on a report is very easy:
Insert a text box in the detail section.
Set its Control Source property to

=1

Set its Running Sum property to Over Groups.
Best wishes,
Hans

siamandm
BronzeLounger
Posts: 1232
Joined: 01 May 2016, 09:58

Re: aut0-numbering row in continuous form

Post by siamandm »

Ok Hans, thanks alot