In Access97 VBA you refer to a DAO in the following format Report!ReportName.ObjectName.Property


What I'm trying to do is use a variable inside this reference. I have a form in which users can change a specific property of an OLE Object (namely chart type) of various reports. Right now i'm using a simple case statement with all the report names but whenever I add a new report I have to make sure and add it to the case statement.


Any help is greatly appreciated


thanks