Help !!!

[paul.uk]

I would like to navigate the database with a combo list ( there are 10 names in the list) and use the findfirst method on the “ AUTHOR” field to move to the selected record.
I found this example on the net for the commanFIND_click and tried to use it for the combolist but it doesn’t work. I get the run time error ‘3426’ “this action was cancelled by an associated object.”
How do I code the FINDFIRST method ??
Thanks for your help.

Private Sub cbolist_Click ()
Dim strName as string

StrName = cbolist.text
If Trim(strName) <> "" Then
StrName = "Author = '" + StrName + "'"
Data1.Recordset.FindFirst StrName
End If

End Sub

[JonnyCab]

I guessing from the code you supplied that you are using ADO. If so, there is no findfirst method... instead use

Data1.Recordset.MoveFirst
Data1.Recordset.Find StrName

Your StrName creation looks ok to me.