>Mike,
>
>Hi Mike. So which one is the "safe select" way?
>
>This:
>
>
>myGrid.RecordSource = ""
>myCA.CursorFill()
>myGrid.RecordSource = myCA.Alias
>
>
>Or this:
>
>
>myGrid.RecordSource = "Tempdata"
>myCA.CursorFill()
>myGrid.RecordSource = myCA.Alias
>
>
>I have been employing the second one ever since with success. It all went beserk when I decided NOT to have all the fields in the CA shown in the grid. It loads up well upon Init(). But upon encountering CursorFill(), it shows the same number of columns as before, albeit different column content.
>
>For example, if CA has fields A, B, C, D, E, but the grid only shows fields A, C, D. After 2nd CursorFill, it will show fields A, B, C, and not A, C, D.
>
>FYI, the columns are created programmatically via a table containing metadata of fields A, C, D - those that are to be show on grid.
>
>Dennis
None of them. Read Andy's article
Using Safe Select approach to preserve the grid
If it's not broken, fix it until it is.
My Blog