Add a field to a form that is record number

[John]

Is there a way to set a function to a field control source that will just
number the record? Example below, I am looking on how to program column #3

Name City Record #
John Chicago 1
Steve Detroit 2
Terry Honolulu 3

 

[Marshall Barton]

Is there a way to set a function to a field control source that will just
number the record? Example below, I am looking on how to program column #3

Name City Record #
John Chicago 1
Steve Detroit 2
Terry Honolulu 3

You should be able to adapt this:
http://www.lebans.com/rownumber.htm

Note that doing this in a reports is much easier using a
RunningSum text box.