auto fill two fields base off a date

[paaap]

What I have is three fields ... EPIC Date, Shipping Date, Email Date
What I want to do is from the date in "EPIC Date" have it auto fill the other two fields. the shipping date should be 14 days before the "EPIC Date" and the Email Date should be 3 days

[mcupito]

Look into the

DateAdd()

function.

http://office.microsoft.com/en-us/ac...001228810.aspx

So on the AfterUpdate event on the EPIC Date "field", use the DateAdd() function to add dates into your other two fields based on what you already know.

[zmbd]

Any reason why you are storing the calculated data?
Normally one would do this in the query with a calculated field, only storing something like the actual shippment date for record keeping.

[NeoPa]

MCupito points you in the right direction for the how, but, like zmbd, I'd advise that you don't store calculated data in a database. Calculate it when needed instead.

For more on this see Database Normalisation and Table Structures.