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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KmhComputer - 30 Apr 2006 00:54 GMT

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.

Reply to this Message

Tom Wickerath - 30 Apr 2006 02:56 GMT

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
__________________________________________

> 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
[quoted text clipped - 13 lines]
>
> Thanks for any help you can give.

Reply to this Message

KmhComputer - 30 Apr 2006 03:29 GMT

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

> Perhaps this is what you are looking for?
>
[quoted text clipped - 27 lines]
> >
> > Thanks for any help you can give.

Reply to this Message

Tom Wickerath - 30 Apr 2006 03:36 GMT

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
__________________________________________

> 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

Reply to this Message