Text in footer

[programmingrookie]

I have a report with page breaks between departments, and the department name
is kept in a text box. I want to add a text box to the page footer that also
displays the department name that appears on that page. When I try to use
the same control source, the names appear but not in the correct order. For
instance, if Dept. A appears over two pages, the name "Dept. A" appears on
the first page, but "Dept. B" appears on second page, etc.

I also tried to set the control source of the footer text box to equal the
value of the department name on the current page.

me.footertxtbox = me.departmentname

This also does not work. In fact, the footer textbox does not appear on the
report at all.

 

[Duane Hookom]

I would try place a text box in the detail section:
Name: txtDeptName
Control Source: [DepartmentNameField]
Then add a text box to the Page Footer:
Control Source: =txtDeptName