I've got a form, let's say "Customer" and a datasheet subform inserted in "Customer", let's call it "Orders". The records displayed in "Orders" are linked to the current record in "Customer". I would like to do automatically (via a command button and a macro), what i do now manually:
1- copy the records of the "Orders" datasheet subform for a given "Customer" record
2- paste them in an MS Excel worksheet.
This copy-and-paste operation is very easy, but I've haven't find yet any way to automatize it...
Any code template? Any idea? My wish would be to insert a command button on the "Customer" form to export the "Orders" data to MS Excel.