Datasheet Subform needs certain fields to default to another field's value
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.