I am running this Code on a button click.
Private Sub NotifyBtn_Click()
If Forms![Employee Frm]!Status = 1 Then
DoCmd.OpenReport "Employee Email New", acViewPreview, "", "", acNormal
End If
If Forms![Employee Frm]!Status = 2 Then
DoCmd.OpenReport "Employee Email Revised", acViewPreview, "", "", acNormal
End If
If Forms![Employee Frm]!Status = 3 Then
DoCmd.OpenReport "Employee Email Complete", acViewPreview, "", "", acNormal
End If
DoCmd.RunCommand acCmdSend
End Sub
The problem is....the DoCmd.Runcommand acCmdSend runs before I see the report that is opened by the code above. I want it to wait until the Report is showing and then run. The Report Event selections do not give me any Event Items that would run After the report is open or I would put the DoCmd code on the report itself.
So, I though a delay timer of some sort would give the report time to show before doing the DoCmd action.