I have a sub form in Access 2007 in a main form, its fun off a field called Part Numbers, when each of the same part numbers are entrered the sub from works well for me, however I would like a colume in the sub form what counts the entries, eg row 1, row 2 row 3 etc, we do have the Record Selector on the bottom of the sub form but would like to have a colume on the left hand side with auto numbers on 1, 2, 3, 4, as each record is storted in the sub form the nubmers go up by 1.
Start Free Trial