ControlSource on text box in Group Header

[MartyO]

When I print/preview my report, I pass it the grouping from the form it was
called from, and I set the GroupLevel(0) in the Open event of the Report,
this works fine.
I'm using Me.GroupLevel(0).ControlSource = strGroupHeader

Inside of that GroupHeader is a text box that I want to set the
controlsource to be the appropriate field from the table corresponding to the
Group level setting.
I'm using Me.txtGroup0Header.Controlsource = strGroup0Header
(where strGroup0Header is set to something like "Year". It won't let me do
this in the Report Open event or the GroupHeader0_Format event or the Print
event.
Where and how should I do this?
Thanks in advance!
Marty

 

[Allen Browne]

The code looks okay, but Year is a function name, and it tends to confuse
Access.

You might be able to solve the problem by aliasing the field in a query.

Also, make sure you have unchecked the Name AutoCorrect boxes under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html

Also, if you want a list of names to avoid using for your fields, see:
http://allenbrowne.com/AppIssueBadWord.html