Prev: Criteria from form on report
Next: Rounding Averages on my Report
From: mrashid on 26 Apr 2010 16:05
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!
From: Duane Hookom on 26 Apr 2010 17:45
Not enough information...
Are the dynamic columns derived based on months?
Why are they dynamic?
How do you get and set the record source of the report?

--
Duane Hookom
Microsoft Access MVP


"mrashid" wrote:

> 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!
From: Allen Browne on 26 Apr 2010 23:43
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: Criteria from form on report
Next: Rounding Averages on my Report