Unanswered: Open a new isntance of the same report?
Hi. I have a datasheet where if you click on an item it opens up a report about that item. At the moment, If i open one report, then go back to the datasheet and try open another report, it will just bring the first one back into focus.
Is there any way I can make it open a new instance of a report regardless if it's already open showing other data?
I'm not sure what you mean by object. Basically from the list of records, when i click on one it runs DoCmd.Open Report RentReport,,,[ID]=Me.ID, and that opens the report fine. If i then leave it open and click on the next row's link (so it's the same function but ID will be different), the first report gets focus and nothing new opens.
X can be whatever you want to name it, provided it meets Access naming conventions (not a reserved word, alpha-numeric with underscores or hyphens I think are the rules). Y however needs to be an object or a variable or whatever you want to declare X as.