Default Value in Form not picked up in Table

[Quan9r]

I have a form with a bound field [Followupdate] I also have another date field [Labdate]: What I'm trying to do is automatically fill the [Followupdate]with a date of 90 days after the [Labdate].
I have tried a couple things 1 - set the default in the form for the [Labdate] field as: [Labdate]+90 but it doesn't fill in either the table or the form. 2 - I changed the control source from [Followupdate] to [Labdate]+90 - That fills in the form but not the table.

Any suggestions? I'm working in the detail section of the form do I need to try something else?

 

[jhall156]

in your FollowUpDate DefaultValue property put
DateAdd("d",90,[text0]).

If it's always 90 days you shouldn't store it though. As a general rule you shouldn't store calculated values. JHall