B
Biggles
I have a form where users can choose the way they want their report sorted,
by choosing a drop down box and changing the group header to that selection.
They can also filter the report using the selection code from Allen Browne.
I have the report header change based on the grouping method like so:
="Open Issues by " & [Forms]![frmallopen_select]![GRPSELECT].Column(1)
So the results of this are: Open Issues by Department
All this works fine.
I would like to add a field to this header that indicates the value of the
grpselect.column(1) field, i.e. if the selection is Department, I want this
field to indicate Audit, Commerical Lending, etc. How do I do this?
by choosing a drop down box and changing the group header to that selection.
They can also filter the report using the selection code from Allen Browne.
I have the report header change based on the grouping method like so:
="Open Issues by " & [Forms]![frmallopen_select]![GRPSELECT].Column(1)
So the results of this are: Open Issues by Department
All this works fine.
I would like to add a field to this header that indicates the value of the
grpselect.column(1) field, i.e. if the selection is Department, I want this
field to indicate Audit, Commerical Lending, etc. How do I do this?