How create new record when entering data in current record
Posted on 2013-12-31
Using a form in datasheet view mode, I have a field named "NextDueDate". This is a date field, short date format. When the user has made an entry in this field I want a new record to automatically be created with the same date just entered populated to a field named "DueDate" in the new record.
What would the afterupdate event be for the field "NextDueDate" on the form?