DateAdd on afterUdate

[soundsfishy]

I have 2 date fields on a form. I need the second date field to show 30 days after a date has been entered in the first field.

How how I use dateAdd function in the afterUpdate Event in the first field.

 

[bjackson]

=dateadd("y",30,[nameofdatefield1])

 

[Mile-O]

er, actually, it's this:

=DateAdd("d", 30, [YourFirstDateField1])

 

[bjackson]

as is typical in access there is always more than 1 way,
dateadd("y",30,[nameofdatefield1]) will also give you
the correct date

 

[Mile-O]

Sorry, saw the "y" bit and thought you were adding 30 years.

Monday mornings

 

[soundsfishy]

Thanks everyone!