Hi
i would like to have an auto numbering for the rows inside continues sub form how I do this, please?
regards
aut0-numbering row in continuous form
-
- BronzeLounger
- Posts: 1232
- Joined: 01 May 2016, 09:58
-
- Administrator
- Posts: 78515
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: aut0-numbering row in continuous form
Should the numbering be stored in the corresponding table, or is it for display purposes only?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1232
- Joined: 01 May 2016, 09:58
Re: aut0-numbering row in continuous form
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
-
- Administrator
- Posts: 78515
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: aut0-numbering row in continuous form
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.
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
Hans
-
- BronzeLounger
- Posts: 1232
- Joined: 01 May 2016, 09:58