Trying to Automatically update date within form

[accesskid]

I am family with the refresh and requiry for dates but what i am looking to do is;

in my database i have a number of assets and want to

automatically update the replacement date by using the purchased date

and life cycle of the asset.

I have came up with this and its not working so need help if anyone knows the correct code.



Me.Replacement_Date = DateAdd(Me.Purchased_Date, Me.LifeCycle, Me.Replacement_Date) = Now

thank you

[NTC]

Me.Replacement_Date = DateAdd(Me.Purchased_Date, Me.LifeCycle, Me.Replacement_Date) = Now

well you can't have me.replacement date twice....and that = Now also can't be there.....

so if the me.lifecycle is in quantity of days? ....then you simply add lifecycle days to purchased date - - and that's it....

[accesskid]

yeah i see what your saying but im struggling to grasp what the code is going to look like to add the dates together and the lifecycle is simply in years, could you possibly help me with an example.............

[NTC]

research the DateAdd method ; and do a couple of simple math trials in your application to verify it works - so you have a handle on that syntax.

then you need only convert years to days with something like:
Dim LifeCycleDays as Integer
LifeCycleDays = Me.LifeCycle * 365

and you use LifeCycleDays in your DateAdd formula.

Hope it helps.

[accesskid]

I have managed to do it thanks a different way by working it out, thanks anyway