Publich to word - single record

[DrSmyth]

Hi,

I have a report which is generated from a form. The form filters the report to show just one record. IO use the following code to do this:

    Dim stDocName As String
    Dim stLinkCriteria As String
   
     
    stLinkCriteria = "[ID]=" & Me![ID]
    stDocName = "Rep_ReferralFormPM_FPM"
 
    DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria

My aim is to output this report (with the single record) to Word. I know that i could use a mailmerge to do this, but I want to get away from having dedicated word document for the output (i update this quite frequently and it's easier if i only have to update the database as opposed to updating the database and a word document)

Hope this is clear, can anybody help?

 

[mp9]

Try the OutputTo macro action or VBA method.

http://www22.brinkster.com/accessory/

 

[belovedcej]

Once your report is in print preview mode, go to Tools, Office Links, Publish with Word.

 

[mp9]

And your code looks wizard-created: replace all your previous code with one line:

DoCmd.OpenReport "Rep_ReferralFormPM_FPM", acNormal, , "[ID]=" & Me![ID]

http://www22.brinkster.com/accessory/

 

[DrSmyth]

Hi,

It's ok, I've solved the problem. I just had to put a filter on the report so it only shows the current record from the form

ID =[Forms]![Referrals Edit]![id]

I then used the output to method as suggested by mp9:

DoCmd.OutputTo acReport, stDocName, acFormatRTF, stNewDocName, True

seems to work OK. Thanks for the pointer



seems to have done the trick