K
KC
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
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