Calculating Date Question

[jessicamosby]

I have created a form in Access 2007 that includes two specific fields:

Distribution Date - where I have the control source assigned to =Date()
Due Date - where I have the control source assigned to =Date()=14



Both work great. However, the users of the database want to be able to have a set 14 day turn-around (for the Due Date), but also want to be able to override it if they need to. Is this even possible? I don't think so, but then I am only a novice at this so I thought I would ask those who have much more experience.

I appreciate any help!

[jessicamosby]

Sorry - Due Date should be =DATE()+14. (forgot to hit the shift key )

[amrut]

Instead of control source, use it as default value. Other option is to use unbound text boxes for both and then the AfterUpdate event of the Distribution date to assign Distribution Date+14 to the due date text box. If required, users can change it.