automate hiding the report footer

[buzz]

Sorry if this shows up as a duplicate post. I initially posted this under
Access Database programming and wanted it under Reports.

My report is displaying data sections based on a user id with totals at the
end of each section and at the end of the report; the report footer totals it
for all users. What I'd like to do is take a command and see if the first
user id for the report is different than the last user id for the report; if
it is display the report footer but if it is not to indicate there's only one
user section, hide the report footer (because the report footer would then
match the section totals and it's redundant data).

 

[buzz]

I am aware of the ReportFooter proprty visible will do what I want; I just
want to know how to change it through code for this scenario.

 

[buzz]

Here's the resolution I got on another post that works:

Add an unbound control to the UserID Group Header.
Set it's Control Source to
= 1
Set it's Running Sum property to Over All.
Name this control "CountGroups"
You can make this control Not Visible.

Code the Report Footer Format event:
Cancel = [CountGroups] = 1