Re: overflow error in opening form

[alicejwz]

Re: overflow error in opening form

Hi everyone,

I'm having trouble in opening a main form w/ a subform.
when I try to open the main form it stops at the main form Form_error subroutine w/ 'overflow' error.
'the DataErr is 2585
Private Sub Form_Error(DataErr As Integer, Response As Integer)

Select Case DataErr
-->breaks here Case -2147467259
Response = acDataErrContinue
Case Else
Response = acDataErrDisplay
End Select

Why is the error occurring? How can I fix this?
I'm using AC2K & SQL Server 2K.
Thank you much!
End Sub

 

[boblarson]

You have:

DataErr As Integer

and an Integer will not fit -2147467259, it has to be a LONG.