>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

If you know the column number, i.e. if you column number actually is .ColumnCount, you should be able to use the .Columns(n) syntax, e.g.

THISFORM.pgframe.page1.grid.Columns(THISFORM.pgframe.page1.grid.ColumnCount).field.Value

Bill