TimeStamp Record After Update event and copy data into another form

[blues763]

Hi all,

I'm back again with another challenge in my working life :banghead:....

I have a simple data entry form on which there are about 30 to 40 data fields to be update by users. One of the field is called "Stage" which is a combo box with 2 entries "Formal Case" and "Informal Case" with no default value whien a form is first opened.
Users will normally create a data entry which updates the table and save.
However if in future users open any one existing record and try to change Stage field from Informal to Formal or vice a versa I would then like this action to
1) update a time stamp concatinated with the stage change value in a text field perhaps
2) save/close the form
3) open a new form with all the existing entries(plus changed status of "Stage Field") with a new record ID and new time stamp.

Hope I have been able to explain this appropriately.

Any guidance would be greatly appreciated!!!

 

[GinaWhipp]

I'm not sure I got what you are trying to but perhaps this will help...

1. Logging changes examples...

Field
http://www.access-diva.com/vba10.html

OR, if you are just looking for a Time/Date stamp you could be something in the On_Dirty event of the Form and store the updated Time/Date in a field.

2. Not sure why you would need a separate Save/Close because Access automatically saves. Unless, you are doing something to prevent the save.

3. You want to create a new Record once all the changes are made? Just create a Log table as in in 1. and then you'll have a History of all the changes which you can view anytime and no need to create a new record causing your database to store redundant data.