>Hi,
>
>You might try making the actual table the gird's record source.
>
>Select A
>use test_table
>
>I think if you want to select a cursor from the test_table to be displayed as the grid's record source, you must re-initialize the grids record source by setting it to "" and then passing the new cursor to the grid's record source property each time a new cursor is created. Even thought the cursor is created exactly the same each time, it will have a new window's handle that the grid really uses to find its record source. Passing the "" (e.g. double quote) to the gird's record source property and then passing the cursor to the grid's record source property forces the grid to properly reference the current cursor per its window's OS handle.

Thank you Leland. Yea, I was not using the "" around my cursor name. Got it working. But the part that still does not work is that the grid displays only one records, whereas, based on the select statement, there are many records in the cursor.

- Ravi