Setting default value in form control from another control

[PaulA]

Greetings,

I want to set a default date value in a form control based on a date value in another control using the dateadd function. I want this default value to be able to be modified if needed.

Is this possible? The field remains blank even when there is a value in the source control. I used the function dateadd("d", 90, [SourceControlName]).

If this won't work, any suggestions?

Thanks!

 

[Mark_]

Are both forms open when you do this?
Also, what event are you using to fill your field?

 

[PaulA]

Thanks - the source field actually comes from another table and won't be updating it. I was hoping to use it for this form. I can do a dlookup and use that for the calculation.

thanks.

 

[Mark_]

PaulA,

If you are saving it, you can also set a Default Value on the Data tab for the Text box in its properties. I am under the impression that your end users can change this in some cases?

 

[PaulA]

Thanks, I got it to work.