NEWBIE:Help

  • Thread starter Thread starter Clayton Jones
  • Start date Start date
C

Clayton Jones

Firstly my appology for being such a novice, but we all have to start
somewhere.

My Question:

I have a form which has two date fields present, Contract Start &
Contract End.

The start date is entered by the user, and the end date is calculated
as start date + 6 months etc, that works fine.

My problem is when I save the record as a whole the calculated end
date is not saved in the table. How can I get this calculated Value
to be saved in the specific field and table that I want.

In anticipation, Thanks
 
If [Contract End] is a bound control, and it just isn't saving, then you
could commit it by using your form's before update event procedure with
something like:
me![Contract End]=me![Contract End]

HTH,
Jeff
 
Firstly my appology for being such a novice, but we all have to start
somewhere.

My Question:

I have a form which has two date fields present, Contract Start &
Contract End.

The start date is entered by the user, and the end date is calculated
as start date + 6 months etc, that works fine.

My problem is when I save the record as a whole the calculated end
date is not saved in the table. How can I get this calculated Value
to be saved in the specific field and table that I want.

In anticipation, Thanks
Click to expand...

There is normally NO NEED to save the End Date in any table.
As long as you have the saved [Start Date] in the table, the End Date
can be computed using the expression:
=DateAdd("m",6,[Start Date])

I would suggest you search through more of these posts for more
information on storing calculated data.
(or search
http://groups.google.com
for additional comments on storing calculated data.
I got over 8000 hits.
Search for "storing calculated" (without the quotes).)
 
Back
Top