Issues Creating an Access Report Programmatically

[rmurgia]

I am trying to create an Access report programmatically. So far I have been able to accomplish everything except the following:

1) I cannot determine the code to create a Page Footer

Set TextBox = CreateReportControl(strDynamicFinalReport, acTextBox, acFooter, , strFieldNM, intFieldPos, intFieldLine, intFieldRptWidth, intFieldHeight)

Gave the following Error:
Error Number: 2148 The number you used to refer to the form or report section is invalid

2) I cannot determine the code to create code for the On Close Event

Reports(strDynamicFinalReport).OnClose = "DoCmd.Restore"

Puts the command DoCmd.Restore into the Close property of the report which errors when the report closes.