Subform new rows

[injanib via AccessMonster.com]

Hi All,

My subform is in continous form mode. What I'd like to do is have an unbound
field to show the row number of the subform for each record in the main form.


for example, it should start at 1 for the first row of the subform. Then 2
for the second row and so on. When I open the main form in add mode to enter
new records, the count should start back at 1.

Thanks in advance

 

[Jeanette Cunningham]

Here is a website with a sample database that shows how to do row numbering.
http://www.lebans.com/rownumber.htm

Download Rownumber.zip



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia