Close form after print report using command button on form

[drp]

Hi

In my databse, When I print a report using command button on form,
I want to close that form instantly i.e By Clicking Single Button Report
should be print simultaniously closing the same form

Immediate help requires

Thanks in advance

 

[John Big Booty]

Your code, at the moment, probably looks something like;

    Dim stDocName As String

    stDocName = "YourReportName"
    DoCmd.OpenReport stDocName, acNormal

Simply change it to;

    Dim stDocName As String

    stDocName = "YourReportName"
    DoCmd.OpenReport stDocName, acNormal
   [B][COLOR="Red"] DoCmd.Close acForm, "YourFormName"[/COLOR][/B]