Table Update

[kp]

Hi,
I have a form field (which is also contained in a table)
that calculates a date from a date entered in another
field on the form. When a date is entered in one field,
the other field calculates and displays the desired date
resulting from the calculation. How do I get this
calculated date/value to be posted/updated in the table
the form is derrived from?

Thanks in advance.

 

[Rick Brandt]

Hi,
I have a form field (which is also contained in a table)
that calculates a date from a date entered in another
field on the form. When a date is entered in one field,
the other field calculates and displays the desired date
resulting from the calculation. How do I get this
calculated date/value to be posted/updated in the table
the form is derrived from?

If you can calculate it, it doesn't need to be stored (nor should it be).

 

[Jim Allensworth]

Hi,
I have a form field (which is also contained in a table)
that calculates a date from a date entered in another
field on the form. When a date is entered in one field,
the other field calculates and displays the desired date
resulting from the calculation. How do I get this
calculated date/value to be posted/updated in the table
the form is derrived from?

Thanks in advance.

How about...

Me.MyDateField = [the calculated date]
Me.Dirty = False

?

- Jim

 

[Jim Allensworth]

If you can calculate it, it doesn't need to be stored (nor should it be).

I think that should be:
If it can be calculated *later*, it shouldn't be stored. There are
valid reasons to store the results of a calculation.

- Jim