Hi All,

Is it possible to seek a record in a cursor, I can't seem to do this and was hoping for some guidance.

Here's the sql in my grids recordsource:

select name, yr_bred from master where type = "B" order by name into cursor addfoal noconsole

The grids recordsourcetype is set to 4-SQL statement.

There is a textbox on the form where the user may enter the record they desire and I would like for them to be able to "Seek" the record but I'm getting a "table not indexed" message.

The idea would be for the grid to be refreshed with the record being "seeked" showing up in the middle of the grid itself.

The sql creates a cursor with about 15,000 records from a table of 23,000+.

Any help would be appreciated.

Thanks,

Jim Harvey
jharvey@netrax.net