Use a textbox date value to calculate another date

[chrisdedobb]

Here is my situation:

I have a db that has a date field (short date format) that represents the date a job opens.
In addition, I have 12 other fields that are proposed dates that represent a "goal" to make a selection. Every one of these fields could be autopopulated with a goal date if the open date is filled out.

For example, I fill Open date with 11/2/2004. The first goal date should be 14 days later, the next goal date should be 28 days from the open date and so on. The goals should increase by 14 days each time.

I am pretty sure this can be done, but I am having trouble doing it.
Any help would be great!

 

[WayneRyan]

Chris,

First, don't store anything you can calculate. But in this instance,
I have no further ideas, cause I don't know what you're doing.

Use the AfterUpdate event of your date field:

Me.SecondDate = DateAdd("d", 14, Me.FirstDate)
Me.ThirdDate = DateAdd("d", 28, Me.FirstDate)
.
.
.

Wayne

 

[Rich]

Sounds as though you've re-created a spreadsheet in Access. Try searching here for articles on Normalisation

 

[chrisdedobb]

Thanks

Thanks for the help!

I am not storing the calculated fields. Just displaying the calculated proposed dates next to a field that holds that actual date.

I guess I did not understand the Me. part of the string. I figured out what it does now though.

Thanks agian!