Numbering records on a form

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
 
K

KC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top