>Hi
>
>What is the best way to requery a grid with a RO cursor in it, whenever I requery the cursor, the grid is just blank.
>
>Any ideas?
>Thanks
>Kev
Kevin,
If cursor is RO then set RecordSourceType = 4 (SQL) and put your SQL as a string to RecordSource. hen all you need is grid.refresh. Otherwise at least do :
.RecordSource=''
* update cursor
.Recordsource = 'cursorname'
The grid might go blank with the first option if your where clause points to afield that's not indexed in base table.
Cetin