Update Dates in Form Field Automatically

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

Marshall Barton

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top