moving text from one field to another

[veder]

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What
I want to happen is that when a user clicks in the Weekly update field, the
text that is in there should pop down to the Historical field and have the
date post for the move next to the text in the historical field. I don't know if this is a click action, if its' a macro or if it's even possible. Any
help would be greatly appreciated!!


Thanks!!!

 

[ejstefl]

There are many ways to do this, but the easiest is probably to normalize your table. You could create a separate table called tblUpdates (or whatever you want). The fields would then be UpdateID, the Primary Key of your other table, UpdateDate, and UpdateText.

Then, set up a subform for this new table. In this way, it will let you keep as many updates as you need.