Autofill possible???

[pdbowling]

Hi, I have two date fields next to one another in a database, one is always variable so must be entered but the second is ALWAYS 3 years - 1 day from the first. I've been asked to have the second autofill after the first is entered. Possible???????
Thank
PB

 

[Rich]

Look up the DateAdd function

 

[pdbowling]

OK

Great, now here's the stupid question. Where do I put it? This is the example in the dateAd function

= DateAdd("d", 30, [OrderDate])
where order date is the base date

Where do I put this???? Thanks again for your assistance.
PB

 

[directormac]

If you're entering the info on a form, put a macro or VBA sub in the AfterUpdate event property of the first field's control that will make the value of the second field's control equal to your DateAdd statement.

--Dating Mac

 

[pdbowling]

OK

Great, now here's the stupid question. Where do I put it? This is the example in the dateAd function

= DateAdd("d", 30, [OrderDate])
where order date is the base date

Where do I put this???? Thanks again for your assistance.
PB

 

[directormac]

deja vu

Are you intentionally repeating yourself, or is this some strange glitch w/ the forum's ware?

Open the properties for control #1. Select the AfterUpdate property. Tell it to run a macro. In that macro, set the value for control #2 to the result of your formula.

 

[pdbowling]

Repeats

Don't know what happened, maybe a stray mouse click or something. Wasn't meaning to repost. Thanks for all your help.
PB