I am having a listbox in the report footer. I would like to change the row source of the listbox dynamically. Where should I add the code to specify the listbox rowsource.

I tried adding the row source property in the reports's detail print and report footer print.. Nothing worked out...

You need to put the code to change the rowsource in the event which you want to trigger the change.

I.e. If the rowsource is going to change each time the Report opens, then put it in the Reports Open event.

HTH,
Patrick