Command Button

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

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
 
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
 
Back
Top