Operation is not supported for this type of object. (Error 3251) (1 Viewer)

foxtet

Registered User.
Local time
Today, 14:10
Joined
May 21, 2011
Messages
129
Private Sub Form_AfterUpdate()
Dim lngSNO As Long
Dim frm As Form
Dim rs As DAO.Recordset
If IsFormLoaded("frmCargoStatus") Then
Set frm = Forms("frmCargoStatus")("tblCargoStatus subform").Form
lngSNO = frm!Sno
frm.Requery
Set rs = frm.RecordsetClone
rs.FindFirst "[sno] = " & lngSNO
If Not rs.NoMatch Then frm.Bookmark = rs.Bookmark
rs.Close
Set rs = Nothing
Set frm = Nothing
End If
End Sub

When this code executes it gives error Operation is not supported for this type of object. (Error 3251)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:10
Joined
May 7, 2009
Messages
19,230
on which line does it fault? is it a linked table?
 
Last edited:

foxtet

Registered User.
Local time
Today, 14:10
Joined
May 21, 2011
Messages
129
on which line does it fault? is it a linked table?
No error line is seen. just a message only.
when add records to the form in Assessment notice tab this error occurs.

Plz have look
foxtet
 

Attachments

  • ErrorObject.zip
    426.8 KB · Views: 304

Users who are viewing this thread

Top Bottom