Updating a field on Datasheet

[hascons]

Hello,



I have a Main form with a Datasheet Subform to display records. One of the fields is a CheckBox. What I'm trying to do is update another field on the Datasheet when the value of the CheckBox Changes ( Eg. When true Add 3 to another field, When False Make other Field 0 ). I'm trying to use the AFTERUPDATE Property of the checkbox with recordset clone to accomplish this, but this doesn't seam to work.

The following code is what I've tried

Private Sub Foreman_AfterUpdate()

Set rst = Me.RecordsetClone

        If rst![Foreman] = True Then
            rst.Edit
            rst![AdditionalWage] = rst![AdditionalWage] + 3
            rst.Update
        Else
            rst.Edit
            rst![AdditionalWage] = 0
            rst.Update
        End If
    
rst.Close
Set rst = Nothing

Is there another Property I should be using Instead?

Steve

[RuralGuy]

Assuming the ComboBox is in the same record as the AdditionalWage control, you can reference it directly in the SubForm. No need to use the underlying RecordSet or its Clone.
Me.AdditionalWage = Me.AdditionalWage + 3
...or...
Me.AdditionalWage = 0

[hascons]

Thank You Rural Guy

I don't know why I thought a Datasheet was different than a single entry form.

I just needed to add Me.Requery to update the sheet after the Check box click.

[RuralGuy]

Me.Refresh would probably have been enough. Me.Requery takes you back to the beginning of the Recordset.