save/print/close

I have a form that creates a new ticket. Click save on the form and the form
closes and updates the form underneath. I would like to print a report from
this form when I hit the save button all at the same time.
>
Here is what I have been working with.
>
Private Sub btnAddNewMaint_Click()
Dim stDocName As String
Dim stReportName As String
>
stDocName = "frmCustomer"
stReportName = "rptMaintTicket"
>
MsgBox "Print a copy for tech to printer xxxxxxxx.", vbOKOnly, "Tech
Ticket"
>
DoCmd.OpenReport stReportName, acPreview
DoCmd.Close
>
DoCmd.OpenForm stDocName
'refresh
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
>
End Sub
>
This seems to flash the Preview screen but closes it. Also the form is left
open.
Can this be done in one action?
>
Gerald
>
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

>The reason it keeps showing a preview is because your code for
>DoCmd.OpenReport has acPreview at the end. I don't remember the exact
>option on it, but it will pop up when you go to change it.
>
>Jason
>>[quoted text clipped - 30 lines]

>I do want it to preview. Problem now is that the report does not have the
>data entered that was just entered. I guess it has not been written to the db
>yet, until it closes. Any other way of doing this?
>
>Gerald
>>[quoted text clipped - 7 lines]