Apologies in advance that this post is not a question, but I thought someone might find it useful and I didn't know where else to post it - apologies also if it's been posted before (but I couldn't find it when I searched!).
I have recently created a "log" which has a "Next Action" column, but using a UserForm to update the record, the previous record is overwritten, loosing the previous Next Action value and as a result, previous actions are lost (and one of the User Requirements was to maintain a history of Next Actions).
To overcome this, when I load an existing record into the UserForm, the value in the Next Action column is written to a Read Only "Previous Actions" Text Box on the UserForm, alongside a "New Action" Text Box. When I write the updated values back to the record, if "New Action" is not blank ie a New Action has been entered, I concatenate ...
- "DD/MM/YY - " (ie TODAY)
- the "New Action" value
- CR
- the "Previous Actions" value
... which writes the New Action AND all the Previous Actions to the record ready for further updates, creating a reverse chronological history of all Next Actions, each one on a new line.
If the "New Action" Text Box is blank, I only write back the "Previous Actions" value.
Just thought someone might find this useful?
I have recently created a "log" which has a "Next Action" column, but using a UserForm to update the record, the previous record is overwritten, loosing the previous Next Action value and as a result, previous actions are lost (and one of the User Requirements was to maintain a history of Next Actions).
To overcome this, when I load an existing record into the UserForm, the value in the Next Action column is written to a Read Only "Previous Actions" Text Box on the UserForm, alongside a "New Action" Text Box. When I write the updated values back to the record, if "New Action" is not blank ie a New Action has been entered, I concatenate ...
- "DD/MM/YY - " (ie TODAY)
- the "New Action" value
- CR
- the "Previous Actions" value
... which writes the New Action AND all the Previous Actions to the record ready for further updates, creating a reverse chronological history of all Next Actions, each one on a new line.
If the "New Action" Text Box is blank, I only write back the "Previous Actions" value.
Just thought someone might find this useful?
