I have a report that has a query with a parameter as a recordsource. I want to pass the parameter value to another sub function and I am using the reportheader_format event to capture and pass the parameter. Everything seems to be working except that the reportheader_format event appears to be firing twice. What triggers this event? Why is it firing twice on opening of report?
Any help is appreciated.