Program Automatic Dates to fill in Custom Form

B

Bridget

I am working on creating a Custom Form for our Client Database. I would like
to be able to Automatically fill in dates for one field after typing the date
into another field.

Example: We need to keep track of Review Dates for Clients.
I have a drop down box to select if it is a Quarterly Review, Semi-Annual,
or Annual.
I have a date box to type in the Last Review Date
I would like to be able to program this so that the NEXT REVIEW DATE will
automatically fill in when the Last Review Date is entered (ex. if its
Quarterly, the date should fill in automatically 3 months from the last date
entered, etc.)

If need be, I can set up for each Review Type to have a seperate section--
"Next Quarterly Review Date", "Next Annual Review Date", etc. and then
program each seperately to fill in 3 months ahead, 6 months ahead, or 12
months ahead.

Is this possible?

Microsoft Outlook 2003
 

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