I am using the following expression to fill a field from a value in Column 1 but I cannot pick up the value of column 2, can anybody tell me why it will not pick up from Column 2?
Private Sub txtTACycle1_Change()
Me.txtCycle1Points.Value = Me.txtTACycle1.Column(1)
Me.txtCycle1Progress.Value = Me.txtCycle1Points - TxtBaselinePoints
Me.txtCycle1DISScore.Value = Me.txtTACycle1.Column(2)