NEWBIE:Help

[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

 

[JeffW]

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

 

[fredg]

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

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).)