Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon Oct 1 09:27:38 CDT 2007
I have a command button in the header of form to print a report. When I click on the button the focus moves from a text box on the form named StartDate to a text box on the form named EndDate. The report does not print. The second time I click the command button the form prints. Code for the command button is below. I tried compacting and repairing the database and moving everything to a new form but to no avail.
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Dim stDocName As String
stDocName = "rpt All Manifolds Oil Gas Water 90 Days"
DoCmd.OpenReport stDocName, acNormal
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.