I have a data object whose source (an excel file) is set at design time. I need to be able to switch between recordsources within it. When I try to set Data1.recordsource at run time, I get "invalid use of property". Is this a weakness of the data object and can anyone suggest a workaround?
