1. When your toolbox is open, make sure that the wizard wand button at the
top of it is selected. This will ensure that the wizard is invoked when you
select the command button.
2. DoCmd.OpenReport stDocName, acViewPreview
"Sean" wrote:
[Quoted Text] > Two quick questions:
>
> 1. When I am building a form and I select a command button, a wizard use to
> pop up and walk me through it but it no longer does. How do I turn the
> wizard back on?
>
> 2. With #1 above... I do not know how to set up this button to open the
> report so the user can view it, it currently just prints; my report is
> "IO_KO_Time_Crosstab". Can someone tell me the command line I should be
> usinging? (See below)
>
> Private Sub Command51_Click()
> Dim stDocName As String
>
> stDocName = "Update_IO_KO"
> DoCmd.OpenQuery stDocName, acNormal, acEdit
>
> stDocName = "IO_KO_Time_Crosstab"
> DoCmd.OpenReport stDocName, acNormal, acEdit
>
>
>
> End Sub
|