Sequential Numbering of Subform Lines (1 Viewer)

F

feinj

OracLegend

Local time

Yesterday, 16:24

Joined

Oct 17, 2007

Messages

42

• Jun 21, 2011

• #1

Is there any way to get a line number field in a subform to automatically increment by (1) based on the previous record starting with the number (1)?

Any help would be greatly appreciated.

 

missinglinq

AWF VIP

Local time

Yesterday, 19:24

Joined

Jun 20, 2003

Messages

6,423

• Jun 21, 2011

• #2

Here's a couple of links for doing this sort of thing:

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

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=309

Linq ;0)>

 

ansentry

Access amateur

Local time

Today, 09:24

Joined

Jun 1, 2003

Messages

995

• Jun 22, 2011

• #3

feinj,

Have a look at my attached sample. I have two types of numbering in it, you can choose which one you want to use.

 

Attachments

• LineNumbering Subform.mdb

  256 KB · Views: 573

F

feinj

OracLegend

Local time

Yesterday, 16:24

Joined

Oct 17, 2007

Messages

42

• Jun 22, 2011

• #4

Thanks for the help. Problem solved.