Numbering records on a form

[Guest]

I have a continuous form that contains bus route stops. These stops have a
field called StopSequence that contains a number indicating its position on
the route (i.e: first stop, second stop, etc.) I am trying to get the
StopSequence to auto generate based on the record's position on the form. If
a stop is the third record on the form then the StopSequence number should be
3. Basically I want to avoid having to manually renumber the StopSequence of
ever bus stop on a route whenever I add or delete a stop. I've tried using a
calculation in a text box that references the previous record, but that means
I have to enter a StopSequence in the previous record and therefore defeats
the purpose. Any help would be greatly appreciated.

KC

 

[Guest]

I should have mentioned that I need to store this value in the record. I have
also tired the method depicted on Stephen Lebans website, but I can only get
the records to number and can't seem to figure out how to store this value in
the table.