Activate

[cunnie76]

Can someone advise.

I have a field on a form that which I want to monitor and store the date when another field is updated. I want this field to automatically update only when data is changed in another field - How can I do this?

Is there special VB code? If so, what is it?

Thanks.

 

[shay]

Try this:

Put this line of code in the AfterUpdate event of the field you will be updating manually:


me.txtDate = date

NB I've called the text box which displays the date txtDate.


hth

shay