i know i've seen this before but i just can't find it.
i have a form; Name, Shop, 3 training dates and 3 calculated fields to show when training is next due (annually). In the BeforeUpdate property i stick the following code:
i have a form; Name, Shop, 3 training dates and 3 calculated fields to show when training is next due (annually). In the BeforeUpdate property i stick the following code:
Code:
Me.Updated = Now()
[\endcode]
If the data in the form is updated it should show the date the update was performed. i've used it in other forms and it works perfectly, but this one has me looking over code and questioning myself more than usual. (i also block editing until a user conciously pushes a button, it doesn't work for me but is does for the users).
It appears that when the calculations are performed Access figures the data is updated and changes the update field, but the calculated dates are not stored they're just there.
Any ideas?
Thanks,
DAve