Adding a different due date for different combo box selections

[pdowg881]

I'm working on a database where users enter an assignment into a datasheet form. Assignments are selected from a combo box that has values stored in a table. After choosing the assignment, the user adds the date it was completed. After this is done, I would like the "Next Due" column to update. Each assignment will have a different next due date, such as one year from the completion date, six months, etc. I don't know how to add different values depending on the combo box selection.

Any help would be appreciated.

[June7]

What are the rules for determining interval?

Options for calculating the NextDue date:

1. hard code those rules in VBA procedure

2. build a table of the intervals for each assignment then join that table to the data input table.

[JLCan]

Hi Pdow!

In the assignment table add an interval field - this will specify the interval for every assignment.

To the combo, add a new column with 0 length holding the integer interval (in days).
In the AfterUpdate event of the combo, after proper check, store the value DateAdd("d", interval, DateCompleted) in the Next Due text box.

Voilà!!!

Good luck, JLCan.

[pdowg881]

Thanks for the help. One follow up question:

Is it generally a better idea to add months instead of days to avoid leap year issues?

[June7]

Why would leap year an issue except for birth dates?

[JLCan]

Hi Pdowg881!

It doesn't really matter as long as you are consistent. Months would definitely avoid leap year bias.

Good luck, JLCantara.