On Activate not working ... receiving wrong data type msg ...

[angelandgreg]

I have a subform and when the user double-clicks on the QteNumber field on the subform table it is suppose to open another form with the data just for the QteNumber (driven by the QuoteID see below).

I am getting the following error message.

"... an expression you entered is the wrong data type for one of the arguments."


I have an Event on Activate:
Private Sub Form_Activate()
On Error GoTo Err_Form_Activate
Me.Requery
If IsLoaded("Customers") Then
If Forms![Customers]![QuoteSummary Subform].Form.RecordsetClone.RecordCount > 0 Then
DoCmd.GoToControl "QuoteID"
DoCmd.FindRecord Forms![Customers]![QuoteSummary Subform].Form![QuoteID]
End If
End If

Exit_Form_Activate:
Exit Sub

Err_Form_Activate:
MsgBox Err.Description
Resume Exit_Form_Activate
End Sub


I can't figure out what and why I am getting the error message. It looks ok to me.

NOTE: i have a back-up copy and it works fine but I have made some changes and now i'm getting the error.

Please help!

 

[angelandgreg]

i don't know how to delete this ...

I figured it out afterall!