Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Before or After Update??

Status
Not open for further replies.

wreded

Technical User
Dec 18, 2001
119
US
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:
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
 
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.

Maybe you can use this code to save the changes:

DoCmd.RunCommand acCmdSaveRecord

Pampers [afro]
Just let it go...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top