Prev: Invalid Sheet Name on Export
Next: IIf works in query but not in report
From: mrashid on 7 Jun 2010 17:34
Thanks folks. I actually got it working using Domain Sum. Sorry for delayed
reply.

Thanks again!

"Allen Browne" wrote:

> Presumably you are using Report_Open to assign the ControlSource of the text
> boxes, based on the actual field names.
>
> You can also assign the ControlSource of the total box in the group footer,
> e.g.:
> Me.Total0.ControlSource = "=Sum([Field99])"
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "mrashid" <mrashid(a)discussions.microsoft.com> wrote in message
> news:9A72E7FA-8E52-46F3-B28A-1C49E7C52DD4(a)microsoft.com...
> > I have a report that dynamically gets control source for five columns
> > based
> > on user input through a form. The report successfully shows text boxes
> > (currency format) with approporiate fields (control source) and respective
> > data. I then have unbound text boxes for each of the five columns to show
> > group totals. I haven't been able to get it working. For example, one of
> > the
> > text boxes' name is txtPeriod1 and based on user selection the field is
> > MAY_PYR. The group total should show Sum(MAY_PYR); it works through hard
> > coding but not dynamically and keeps prompting to enter "txtPeriod1"
> > parameter. Please suggest solution. Thanks in advance!
>
> .
>
 | 
Pages: 1
Prev: Invalid Sheet Name on Export
Next: IIf works in query but not in report