>if i just update the recordsource, the setting of the grid will change back to it orginal setting..
>but is that the only way i can do?

I'm not sure what you mean. I just double checked and I don't lose the grid formatting when I do it.

LOCAL lcSource

* Update data in cursor
* (fill in your code here)

* Reset the grid to show updated data

lcSource = THISFORM.Grid1.RecordSource
THISFORM.Grid1.RecordSource = ""
THISFORM.Grid1.RecordSource = lcSource

You're not changing the name of the RecordSource, are you?