Help!!!

[nyrob609]

Good Morning,

I need assistance I know how to calculate the age using the formula =DateDiff("yyyy", [Birth date], Now())+Int( Format(now(), "mmdd") < Format( [Birth date], "mmdd")). I put the formula in the Default Value section of Field "Age" but is not working. It works in a query no problem but I want to be able that as soon as I put Birth Date in the form the age gets calculated but store in the table.

Is there anyway of doing this?????

 

[HiTechCoach]

The default value gets set when the new record is created and before the user can enter any data. I do not see how the default value will work for you.

I would use the After Update event of the control where you enter the date to place the vale in the desired control.

Note: Normally if is not advised to store calculated values.