Main form contains a subform (datasheet view) that is based on a read-only recordset. A new requirement has added another field to the recordset that must be updated by the user. The field values will always be 0, 1, 2, or 3. I was hoping to allow the user to select an arbitrary number of records in the subform to be updated, then perform some action (click a button, select from a combo box, select a radio button, etc) that would update the underlying table via VBA. But I can’t figure out how to do that…
Any suggestions?
