I am using a grid that has a column with computed values. This column is then compared to a second column (non-computed) via function defined on my form. A third column, where the comparison function is referenced in the controlsource prop, shows the result of the comparison (checkbox). I am using a command button to compute my values and to show the results of the comparison on the grid.

The ControlSource property for each column in the grid is defined as follows:
Col 1: ThisForm.Function1
Col 2: view.Field2
Col 3: ThisForm.CompareFunction1Field2

The problem I am having is the column showing the results of the comparison is not refreshing correctly after the first time the cmd button is clicked. If the button is clicked a second time, the correct results show up. Any suggestions on how to correct this problem. Do I need to compute the values in my view instead of in the form?

Thanks