I have a table called Requests which has an autogenerated ID field (PK). I have a form that contains information for requests. Some of these are recurring requests. When closing out a recurring request, I wish to copy the information to a new record and update the due date to a date that I have calculated (dNextDateDue).
Being a lazy person, I would like to avoid having to copy all the fields from the current record without naming fields.
Anyone have ideas?