Date Issues

[ashleybyrdnc]

I have a form that when you click in it places =Now() is placed in field1, Then once you close the record it places another =Now() in field2 in (Database1). Then this table is appended to another database (datebase2) at the end of the day.

Later on if a change is made to any record in (Database1) I want field2 to changes to =Now(). A time stamp for the change.

My problem comes when I append all new records that were entered today. But then I need to update the records where the field2 was changed. I can't make it determine the difference.

 

[Brianwarnock]

Later on if a change is made to any record in (Database1) I want field2 to changes to =Now(). A time stamp for the change

This is achieved by coding Me.field2=Now() in the Before Update event of the Form used to update the records.

My problem comes when I append all new records that were entered today. But then I need to update the records where the field2 was changed. I can't make it determine the difference

.

If I understand you correctly if no updates have taken place the date part of Field2 will equal the date part of field1, assuming you don't work over midnight, therefore you could compare for this being different, of course this would apply for ever and thus perhaps a different approach is required setting an indicator that a record needs selecting for appending, then running and update query to rest after successful runof the append.

Brian