Dynamic Counter

[Mariner]

I have used Query dynamic counter function from
http://support.microsoft.com/kb/94397/en-us.

The results is displayed in a list box control in a form with Crew Names and
assigned duties. The indicated number is very important as user can keep a
track,as he is adding crew names to a other sub form on the same main form.

Every time mouse pointer passes through a unbound label, or during any other
activity in the form dynamic counter runaway with numbers and dispalyed in
listbox . I tried to reset back it to Zero with many events within the form
controls. Still it is not giving out a reliable Sequence number.
Is there a way to stop this or any other function to generate a reliable
sequence number for my list box?. Thank you very much
Mariner at Sea

 

[Marshall Barton]

I have used Query dynamic counter function from
http://support.microsoft.com/kb/94397/en-us.

The results is displayed in a list box control in a form with Crew Names and
assigned duties. The indicated number is very important as user can keep a
track,as he is adding crew names to a other sub form on the same main form.

Every time mouse pointer passes through a unbound label, or during any other
activity in the form dynamic counter runaway with numbers and dispalyed in
listbox . I tried to reset back it to Zero with many events within the form
controls. Still it is not giving out a reliable Sequence number.
Is there a way to stop this or any other function to generate a reliable
sequence number for my list box?. Thank you very much
Mariner at Sea

That function was only useful in limited situations in
Access 1.x (~15 years ago).

For more general situations, if you want a persistent row
number, you really need to include a field in the table and
calculate the number when the record is added to the table.

If the number does not need to be persistent, then use a
ranking subquery to calculate the number based on some kind
of unique sorting.