>>Hi. I have a grid that can contain one or more columns. In my form init I Delete the Columns that I don't want, based on User Setup tables. The last column is the total column for the row. I want to update the total column whenever a total from one of the other columns is changed. In the LostFocus Event of the subtotals I want to put the code to add the fields. How do I reference the last column of the grid without knowing what column it is?
>>
>>I know I need to use:
>>THISFORM.pgframe.page1.grid.Column??.field.Value and I know that the last column is stored in THISFORM.pgframe.page1.grid.ColumnCount, but how do I put this together???
>>
>>Thanks for your help
>>
>>Sandi Cassidy
>>scassidy@canaccount.com
>
>There is a Columns() collection. So you can use ColumnCount property like:
>
>local loGrid
>loGrid = THISFORM.pgframe.page1.grid
>loGrid.Columns(loGrid.ColumnCount).Text1.Value = somevalue

Thanks to both of you!

Sandi.