Table Update

  • Thread starter Thread starter kp
  • Start date Start date
K

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.
 
kp said:
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?
Click to expand...

If you can calculate it, it doesn't need to be stored (nor should it be).
 
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.
Click to expand...
How about...

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

?

- Jim
 
If you can calculate it, it doesn't need to be stored (nor should it be).
Click to expand...
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
 
Back
Top