Use Access "mail merge report" and print other documents.

[mkranz]

I print out customer letters sorted by state through an Access query. There are other forms unique to those states represented as hypelinks the the same query (some states have more than one form). I'd like to prinout the customer letter and a form unique to that state. The result I'm looking for is that for each Arizona customer letter; a form unique Arizona prints out after the customer letter.

[This message has been edited by mkranz (edited 06-15-2001).]

 

[Fornatian]

Have you tried putting a statement in the OnOpen event of the 1st report suchas:

Private Sub Form_Open(Cancel As Integer)
Docmd.OpenReport "ArizonaForm",acNormal
End Sub

This should open and print your second report invisibly.

Ian