Seek or Find lookups ????

[1712]

I am trying to find a record in an ADO recordset by first getting the option value from a listbox chosen by the user.
I have tried using the seek method like in VB, but get an error "provider does not support necessary interface for index functionality when it tries to execute
rs.index = "primarykey"

Then after I find the record I want to pass the fields data onto another page in a frame that will be bordering the listbox.
Anybody direct me to the best lookup method?

 

[jonscott8]

First and foremost, the underlying provider must support indexes & seeks on the recordset. Use the recordset's supports method to determine that.

Second, only server-side cursors support the seek method.

Third, the recordset object must have been opened using adCmdTableDirect as the command type.

Based on your posting, it cant be determined whether you violated any of these rules, although the error message indicates you have. Jon Hawkins