Need help understanding the FIND method of a recordset.

[Ekliptic]

I'm using the find method of a recordset but am getting the error "Rowset does not support scrolling backwards". I don't understand why I'm getting this error message when my code looks like this: (Note: the default direction to the find method is adSearchForward)

Customers.MoveFirst
If Not Customers.BOF And Not Customers.EOF Then
'******It errors on the next line***********
Customers.Find "CustomerID = 'ALFKI'"

gs_CustomerID = IIf(IsNull(Customers("CustomerID&quot), 0, Customers!CustomerID)

gs_CompanyName = IIf(IsNull(Customers("CompanyName&quot), 0, Customers!CompanyName)

gs_ContactName = IIf(IsNull(Customers("ContactName&quot), 0, Customers!ContactName)
End if

Any help would be appreciated...

tschock

 

[TheInsider]

Try Customers.FindFirst and Customers.FindNext Rob Marriott
robert_a_marriott@yahoo.com

Hire me! Full-time, contract, whatever...shhh don't let my current employer know I said that.

 

[Ekliptic]

Unfortunately I don't think ADO has the findfirst and findnext methods.

 

[dpaulson]

Try this
adSearchForward 'direction to search
adBookmarkFirst = 1 'record to start at

Customers.Find "CustomerID = 'ALFKI'", , adSearchForward, adBookmarkFirst

You could probably issue a .movefirst(to take you to the begging of the recordset) before using your code also.

David Paulson

 

[Ekliptic]

That seemed to work! I guess you have to specify adSearchForward and the adBookmarkFirst even though the default is adSearchForward.

Thanks for your help.