Jeff,

I use paramatarized views for this case; the child view contains all records related to all entries in the Master Table/view. The child view has an index and is related via a SET RELATION. The child view does not have to be queried on every AfterRolColChange, I just refresh the controls. The way I understand it, since the controlsource of the child grid, then, is always in tact, the child grid retains its settings.

Hope this helps.

J

>Hi-
>
>I have two grids on a form. The top grid is the Master Record, and the bottom shows detail.
>
>When the MasterRecord is moved, in the AfterRolColChangeEvent
>I run a SQL to update the control source data used by the detail grid below, and refresh the data in that grid with:
>
>thisform.Jgrid1.recordsource=thisform.Jgrid1.recordsource
>
>Data is refreshed correctly but the bottom detail grid redraws and shows the data with no regard to how the control was initial established, including Column widths, headings, titles and positioning.
>
>This, of course, is not only undesired, it is extremely frustrating.
>
>Any suggestions or ideas as to what I am not doing, or doing incorrectly. I prefer not to go to a list box as it would not have headings.
>
>Thanks for any suggestions.