Hi Kite
There is a few options you have here, 1) if the report is is preview mode on your screen then you can simply go to Tools - Office Links - Publish it with MS Word or 2) if you wish to program this to a command button or simular then use something along the lines of
Dim stDocName As String
stDocName = "Report name goes here"
DoCmd.OutputTo acReport, stDocName
This code will give you the coice of output methods, ie word, excel etc etc
If you like you can further customise this code to specify file name / path etc
Hope this helps
|