I'm using vb6. It is so strange. The application works in one building without problems but in another building down the street they are getting this error (they are running the same files and on the same SQL Server database.
When the users pull down the data and make modifications to the form, they receive this error. The code in the user control (ctlPropLandTab) requery routine is as follows.
-----------------------------------------------------------
Public Sub Requery()
On Error GoTo Requery_Error
m_CasePropLand.Requery
Requery_Exit:
Exit Sub
Requery_Error:
Beep
msg = "ctlPropLandyTab: Requery_Error - BK-ER-" & Format(X, "000") & ": " & Err & vbCrLf & Error
MsgBox "Critical Error - BK-ER-" & Format(X, "000") & ": " & Err & vbCrLf & Error, vbCritical, "Critical Error - ctlPropLandTab: Requery_Error"
Resume Next
End Sub
------------------------------------------------------
m_CasePropLand is linked to a class module (clsCasePropLand)
This is the code for the Requery routine in the class module (clsCasePropLand)
Public Sub Requery()
adoPrimaryRS.Requery
DataMemberChanged "Primary"
End Sub
Thanks