HELP!!! I’m trying to use the example for Northwind given by the above Knowledge Base article. I’ve double checked that I’ve done everything it asked and I’m getting Run-time error 94: Invalid use of Null.
I did notice that although I typed the OnPrint properties in the page header and footer as stated in the article. Access changed (Report)to ([Report]) in both cases.
Can someone help?? The debugger points to the second line of the following function.
Function SetGlobalVar(InReportAs Report)
CurrentGroupVal = InReport!SetGroupVal
End Function
I’m not sure that this example will give me what I need anyhow. In my report, there are 5 groups and 5 additional sort orders. If everything for the 3rd group continues on thenext page, the 2nd and 3rd group headers need to repeat with (continued) beneath the 3rd one. I’ll be grateful for any guidance. THANKS.