How about something like:

select case cmbTermLength
case "1 week"
EndDate = DateAdd ("ww", 1, StartDate)
case "1 month"
EndDate = DateAdd ("m", 1, StartDate)
case "3 months"
EndDate = DateAdd ("m", 3, StartDate)
case "1 year"
EndDate = DateAdd ("yyyy", 1, StartDate)
end select

wrote:

I realize that's what I need to use but I can't get my
formula to work. The user will be selecting from a drop
down with options of 1 week, 1 month, 3 months, 1 year,
for example. So, I tried an IIf with DateAdd using Date
() as today's date. Would you mind sending me a sample
of the statement? THANKS so much.


-----Original Message-----
Assuming you can figure out how to convert what the user

enters into days,

use the DateAdd function to add that many days to

today's date and then

you'll have the desired date.

--

Ken Snell
MS ACCESS MVP

wrote in message
...

In a form I want the user to enter a follow up time,
i.e., 1 week, 1 month, 3 months, etc. Based on that
response I want to store an actual date based on

today's

date plus whatever was chosen as the follow up

timeframe,

1 week would be today + 7. How do I do that?


.