Auto populate Date based on other field.

[louisa]

Hi All ,
Happy new year to you all.
I have 3 fields called "startdate" "duration" and "enddate"

If i enter 09/01/2012 into "startdate" and 12months into duration i want the "enddate" field to automatically add the end date into the field.

Is there a way to do this? I understand i might need to change the duration from a text box to something else which is not a problem. The duration field will vary so not always 12months.

Many thanks

 

[vbaInet]

You don't need an End Date field. Just calculcate it on-the-fly using the DateAdd() function in a textbox.

http://www.techonthenet.com/access/functions/date/dateadd.php

 

[louisa]

I need the a form to pop up from that date, if it is calculated on the fly can the form see the information once the database is opened?

 

[vbaInet]

You've already asked this "pop-up" question on a different thread Louisa. Follow that thread. Your OP has been answered.

 

[louisa]

I only asked on here because if the pop up form cannot work with the EndDate being calculated on the fly then your suggestion would not work for me. However thank you for your advise.

 

[vbaInet]

If you've got a thread about the same question already, you could have simply pointed me to the thread where the question was asked. Remember I posted in that thread too so I know what you're asking.

 

[louisa]

Point taken many apologies, i will await the responses on the other thread now.

 

[vbaInet]

Already responded

 

[johnwatkins35]

Does anyone have an example already setup in a database?