Date Field Control

[Pemapanik]

I added a Date Field to my form so that I can have a calendar popup to select a date. I see there is a field on the control tab to add a default date. I am wondering if I can use another field as the default date. What I am doing is having a deposit Due field that I want to be the Tuesday two weeks before the show. If I can pull up the show date as default then it is easy to select two weeks prior.

[Villeroy]

Base is not able to calculate dates from other dates. This requires a macro to calculate the right Tuesday on every record change and put it to some form control.