Results 1 to 2 of 2

Thread: Using Findfirst

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2008
    Posts
    2

    Using Findfirst

    Hey all, hopefully this is a quick question. I have a button on a form that requeries and send the form to the first record and I am trying to use findfirst to move it back to the desired record.

    Right now I am getting an invalid argument on the last line.

    Here is the code im using
    vb Code:
    1. Private Sub cmdRefresh_Click()
    2. Dim rst As DAO.Recordset
    3. Dim strCriteria As String
    4.  
    5. 'Save the value for the current record
    6. strCriteria = Me.IDString
    7. Set rst = Form_frmEditView.RecordsetClone
    8. 'Requery the form
    9. Me.Requery
    10.  
    11. 'Move back to the original record
    12. rst.FindFirst (strCriteria)
    13. End Sub
    Last edited by Hack; Dec 23rd, 2009 at 12:39 PM. Reason: Added Highlight Tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width