I have a form which is quite complex. It contains the results of several queries on several sub-forms. I don't it taking a while to display, but when I go to print it, Access recalculates it again. It doesn't matter whether I use my command button or the Access print button. My command button is very simple (from the wizard) and looks like :


Private Sub Command12_Click()
On Error GoTo Err_Command12_Click
Dim stDocName As String
Dim MyForm As Form
stDocName = "KPI Results"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_Command12_Click:
Exit Sub

Err_Command12_Click:
MsgBox Err.Description
Resume Exit_Command12_Click

End Sub