Allow Date Change in Default Programmed Date

[Gus]

Hi! Thank you for your time.

I have been trying to program a date calculated in a query. I have two
attributes in a form one is called Date_Action_Required, users enter this
date. The second is called Date_Action_Reminder, this field comes from code
in a query (Date_Action_Reminder: DateAdd("d",-5,[Date_Action_Required]). The
default for Date_Action_Reminder should always be 5 days prior to
Date_Action_Required.

I want the users to have the option of entering any date and if not the
default will remain.

Thank you for your help.

 

[pietlinden]

You can't modify a calculated result in a query. You could set the
default value of that field's control in your form to that function,
though.

 

[Gus]

Can you give please give me a more descriptive idea? Thanks!