Hi There,

Just as the title suggests, is there a way to open a report in Datasheet (Basically a query view).

I'd just set up a query, however, I need to put underlying code into the report so that I can automate opening other objects when the report closes.

I also need it to be in the form of a query so that people can cut and paste it into Excel?

Does one of the methods do this?

Thanks

You can export to excel directly. Add that as an option to your form and use the TransferSpreadsheet method to do it. That will allow the user to either open a form or a report and that way you can make your report format however you want it.

Thanks Pat, that's actually good to know since the cell range goes strait along a line within the excel template. I noticed the cell range can be specified with the method

Cheers

I don't think the cell range can be specified on output. Check the help entry. If you need to poke values into specific cells, you'll need to use VBA.