Microsoft Access 97

  tergit 18:00 17 Mar 2003
Locked

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!!

Thanks

Andy A

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?