Forms and Tables

[Kim M.]

I am in Access 2000 and I have an event in a field on a form that takes a
date and adds 29 days. It works on the form but does not populate the table.
That field in the table is always blank? What am I missing?
thanks

 

[Douglas J. Steele]

Why do you need the field to be stored in the table if it's always supposed
to be 29 days later than the value of another field in the table? Add a
computed field in a query, and use the query wherever you would otherwise
have used the table.

 

[Kipp Woodard]

It sounds like you may have used a formula for the control source of the
control. If that is the case then you need a way to set the value of the
corresponding field in your form's data source.

You might use the form's before update event to set the value of the field.

 

[Kim M.]

Ok, thanks...so how do we do that in 2000? We have both versions, but this
one needs to remain in 2000 for some folks... I am not savy in that version!