You should try the "safe select" approach
Select whatever ... into cursor curdummy
Select cursorThatDrivesTheGrid
Zap
Append from dbf('curDummy')
yourgrid.refresh()
The point here is that you never change the recordsource, so you never lose any of your settings.
>Hi All
>
>I've got a cursor that has a couple of memos in it, so I set up a grid for the non-memo and 2 editboxes for the memo fields on my Search form.
>
>The user can change the contents of the cursor, so in the Click method of the "Search" button I've got
>
>Thisform.GrdLookup.RecordSource = ""
>thisform.GrdLookup.RecordSource = "LookComb"
>
>When the grid first displays, it's showing the 10 columns I want it to show with header captions, etc, but after the 'Search' button is clicked, it displays as if I'd just thrown the cursor at the grid. Yes, I've got each column 'hooked' to its respective field. Why is my grid doing this? Other than to make me a little more crazy, I mean
>
>Dorris