I have a datasheet form, based on a recordset, where a user may enter new (or revise existing) records. Whenever a record is updated, I need to update a field in the underlying recordset that does not appear on the form. I want to use the "AfterUpdate" event to trigger this action. (seems logical enough...)
Is there a way to refer to the recordset directly, or do I need to create a separate SQL statement / recordset / etc. to perform the update?