>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