Update Dates in Form Field Automatically

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have created a form that I need to input a date I have
servreal other field on that form that are 4 months, 6
months and 10 months after the date I input. Is there a
way to enter the one date and have the 4 month, 6 month
and 10 month date autmatically computed? New to Access.
 
Ray said:
I have created a form that I need to input a date I have
servreal other field on that form that are 4 months, 6
months and 10 months after the date I input. Is there a
way to enter the one date and have the 4 month, 6 month
and 10 month date autmatically computed? New to Access.
Click to expand...


If you just want to display the future dates (they should
not be stored in a table!), then just use a text box control
with an expression. E.g.

=DataAdd("m", 4, nameofdatetextbox)

See Help for more details on DateAdd.

Note: Forms have controls (text box, label, combo box, etc)
while tables and queries have fields. The reason I'm
pointing this out is that when you say you "have
several other field on that form", it's not clear whether
you mean controls on the form or fields from a table/query
that is being displayed on the form.
 
Back
Top