Error 3001 please please help

  • Thread starter Thread starter Caroline Duff-Riddell
  • Start date Start date
C

Caroline Duff-Riddell

I have a routine which synchronises the data of a parent
form to the sub form selection. The routine is run on
the "on current" event and works almost all the time.
However, when I do a search using the built in "find"
function on the parent form I get error 3001 invalid
argument on the "findfirst" statement in the code. None of
the argument values can be null. The code is listed below:
Dim frmrst As DAO.Recordset
Dim Sync As String
Dim sync91 As String

Set frmrst = Form_F4_Edit_Claims.RecordsetClone
frmrst.MoveLast
frmrst.MoveFirst

sync91 = BuildCriteria("Claim_ID", dbInteger,
Form_F4_Claim_Pmts.Claim_ID)
Sync = sync91
frmrst.FindFirst Sync

'This is the statement which makes the record required the
current record of the form.
Form_F4_Edit_Claims.Bookmark = frmrst.Bookmark

Please can someone help.
 
Could it be that no match was found?

If Not frmrst.NoMatch Then
Form_F4_Edit_Claims.Bookmark = frmrst.Bookmark
End If
 
Back
Top