F feinj OracLegend Local time Today, 10:04 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.
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 Today, 13:04 Joined Jun 20, 2003 Messages 6,420 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)>
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 Tomorrow, 03:04 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 LineNumbering Subform.mdb 256 KB · Views: 612
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.
F feinj OracLegend Local time Today, 10:04 Joined Oct 17, 2007 Messages 42 Jun 22, 2011 #4 Thanks for the help. Problem solved.