Run-time error 2147352567 (80020009)

  • Thread starter Thread starter evilc
  • Start date Start date
E

evilc

I am receiving this error message when trying to run my form:
Run-time error '-2147352567 (80020009)':

The bound or unbound object frame you tried to edit doesn't contain an OLE
object.

Can someone please help? I am creating a database where you use a calendar
to select the start date and end date for various data. Once the dates are
selected the Subform should automatically prefill with the information from
the query it runs then you click the export button to run the macro to export
the data to an Excel spreadsheet but I keep getting this error when trying to
run the form. Somebody, anybody please help. It may help to know that when
I get the error and click the Debug button it highlights this row: Me.
dteDate1 = Date - 1 Here is the Event for the On Load field for the form:

Private Sub dteDate1_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub


Private Sub dteDate2_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub

Private Sub Form_Load()
Me.dteDate1 = Date - 1
Me.dteDate2 = Date
EscalatedEntrySubform.Requery
End Sub
Private Sub Export_Escalated_Call_Data_Click()
On Error GoTo Err_Export_Escalated_Call_Data_Click

Dim stDocName As String

stDocName = "ExportEscalatedCallData"
DoCmd.RunMacro stDocName

Exit_Export_Escalated_Call_Data_Click:
Exit Sub

Err_Export_Escalated_Call_Data_Click:
MsgBox Err.Description
Resume Exit_Export_Escalated_Call_Data_Click

End Sub

Any help you can offer would be greatly appreciated. Thanks in advance.
 
Back
Top