Access Build event to print form letter

[Lindac9683]

I have built an event attached to a button to print an approval letter on a specific file when approval is received. It prints the letter beautifully. However it also prints the form screen that has the button on it. I've modified the event to close the form before printing the letters and I still get the form printed.

Any ideas on how to fix this?

[Andre]

please post the code you wrote

[Lindac9683]

From the button on my form, I set up a build event with the following sequence:

Close (Form)
Open Query (Today's Approvals)
Requery
Close (Query)
Open Report (Approval Letter)
PrintOut (Pages, from 1 to 1)

This prints the letter beautifully but still prints the form screen even though I closed it. I would like to have it print just the letters and not waste the extra paper on the form screen.

[Andre]

try to start the printout from the opening event of the report not to start it from the form, that should work

[Lindac9683]

I tried taking out the close reference and stripped it down to just Requery, Open Report, PrintOut. I still prints the form screen. Any other ideas?

[Andre]

if i get this right you still start the printout from the from ?! (Take the printout out of this event an use it at the report)
(Private Sub Report_Open(Cancel As Integer)

DoCmd.PrintOut xxxxx

End Sub

maybe it´s possible to attach the databasefile or a part of it?