recordset.find problem!!

[turfbult]

Hi,

I am connecting to a MS Access database and have a click event to find records.

Private Sub cmdQteMainBrowse_Click()

Dim strFind As String

strFind = "surname like '" & txtClientSurname & "*' "
rsRecord.Find strFind
'bind all fields on form
bind_fields

End sub

This works 100% the first time I click find, but as soon as I type in a new surname and click find I get this error...

Provider called a method from IRowSetNotify in the consumer and the method has not yet returned.

Any suggestions?? I presume it has something to do with me not closing/canceling the recordset!!

Thanks.

[chicho_chicho]

Do you have the recordset cursor on the client or the server?

[turfbult]

chicho_chicho,

On the Server!!