Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: help with totals for count text boxes

    I have a report that has 5 text boxes that has controlsource count formulas like this:

    =DCount("*","Age Group: New-Child <1")

    these count boxes work fine. The five count boxes have counts of (5,3,4,2,5). The names of the text boxes are Text19, Text20, Text21, etc.

    What I need is a text box that will give me the total of those 5 count boxes. So the number in the text box should be 19.

    Someone suggested to use:

    =Me.Text19+Me.Text20, etc

    However this did not work.

    Any ideas of how I can create a text box that that total count text boxes?

    Any help would be appreciated

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    As noted elsewhere, Me is invalid outside VBA. Try

    =Text19+Text20...
    Paul

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    thank you very much - your solution worked!!

    Great forum!!

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problem, and welcome to the site by the way.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •