Using Findfirst

[haed34]

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

Private Sub cmdRefresh_Click()
Dim rst As DAO.Recordset
Dim strCriteria As String
 
'Save the value for the current record
strCriteria = Me.IDString
Set rst = Form_frmEditView.RecordsetClone
'Requery the form
Me.Requery
 
'Move back to the original record
rst.FindFirst (strCriteria)
End Sub

[Hack]

I think you have to specifiy the column you are looking at and for string data you need single quotes.(this is just a guess...I haven't use FindFirst in years)

rst.FindFirst "ColumnName = '" & strCriteria & "' "