I have a main form that displays subform records in a datasheet based on selection in main form. A "DefaultPoints" field in the datasheet subform has a value. I need to set the "ActualPoints" field to the default value for that record in the datasheet subform. DefaultsPoints is not edible, but ActualPoints is. After I set the ActualPoints field to the DefaulPoints value, it can be changed by the user.
I'm struggling with how to do this using a datasheet subform and VBA.
Thanks for any help you can provide.