Allowing users to change data in bound fields on form

[Guest]

Hello All,

This is a repeat question with the hopes of getting more detailed answers if
I provide a more detailed question.

I have form that is used to populate data on a table, from which queries are
run. On my form, called 'BD Form', I have several calculated date fields.
The dates are calculated off one field 'Package Mail Date' after a date is
entered, and are the 'Package Mail Date' + 10 days, 15 days or 90 days and
then placed in one of the following fieds respectively:
'10 Day Courtesy Call'
'45 Day Reminder' or
'Expiration Date',
and the Control Source for each looks like this:
=DateSerial(Year([Package Mail Date]),Month([Package Mail
Date]),Day([Package Mail Date]+10))
=DateSerial(Year([Package Mail Date]),Month([Package Mail
Date])+1,Day([Package Mail Date]+15))
=DateSerial(Year([Package Mail Date]),Month([Package Mail
Date])+3,Day([Package Mail Date]+90))

I need to be able to allow users to change the date that is calculated in
the 'Expiration Date' field. I am fairly new to MSA, so idiot proof
instructions are appreciated, and any and all suggestions/assistance are/is
greatly appreciated.

Best Regards,
Jean

 

[Guest]

why not put those calculations into the Default Value property?

-Dorian

 

[Guest]

I've tried that, but then the calculations are incorrect and it shows dates
such as:
10/3/2003
11/8/2003 and
1/22/2004 before I even enter the date into the 'Package Mail Date' field,
which is truly bizarre.