Help! How do I adding a Counter Field to a SubForm?

[KmhComputer]

Please help. I have a Main Form with a Subform. The Main Form contain my
main table data and the Subform contains the Detail Data and the number of
records in this table can vary from 0 to 40. The Main Form is linked to the
SubForm by a CoverID. My client has decided he wants a record counter added
to the SubForm page as such. How can I code in a record counter like below
without actually having to store this information in my Details table?

RecordCount Code Detail1 Detail2 etc.
1 AA1 Blaa Blaa
2 AB2 Blaa Blaa
3 CC1 Blaa Blaa

If there are no sub records associated the main record, the first record in
this
subform is full of zeros and blanks.

Thanks for any help you can give.

 

[Tom Wickerath]

Perhaps this is what you are looking for?

ACC2000: How to Display Line Numbers on Subform Records
http://support.microsoft.com/?id=210340


Disregard the "ACC2000" in the title. This should work in Access 97 ---> 2003.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[KmhComputer]

Thank you so much!!! Works very well! I appreciate it. Sometimes Microsoft
makes it very difficult to track down information on how to do certain
things. I don't know how I missed this one in the documentation. But thank
you so much!

Kathy

 

[Tom Wickerath]

Hi Kathy,

You're very welcome. I'm glad to hear that you got it working. Thank You for
posting back.

Good Luck with your project.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________