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?