I have created a form which requires entry of a date when a task is to be completed by (DateComp). Another control on the same form has a target date (DateArt)which can be calculated backwards from DateComp. I have set the properties in DateArt to have a default value =DateAdd("y",-30,[DateComp]) but this doesn't automatically insert a date.
I have tried a number of things including setting DateArt to not enabled and using a macro to switch DateArt to enabled when DateComp is revised and exited. All dates are in short date format (dd/mm/yyyy). This is driving me barmy and desperate!!
This thread is now locked and can not be replied to.