>Thanks Hillmar and Erick,
>I did try the Into Cursor MyCursor but still had problem updating the grid. The query would run OK and fill the grid when I put it in the load of the form, but when I run the same select statement from a control, the grid inside disappeared.
>
>TIA
Ron,
I see you solved this, but, if you want to have the select from a control, when you re-run the select statement, you need to dis-engage the grid first:
myGrid.RecordSource = ''
select whatever from myTable ... into cursor myCursor
myGrid.RecordSource = 'myCursor'
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges