Access to auto populate a date in field2 once field one is populated

[danaluter]

Hi: I have two fields, First follow up date sent email. I want the second field, Second follow up date sent email, to auto populate seven days into the future. this is on a Access form. How and where would the expression be placed in which field first follow up or second followup field. On the table or the form

[NeoPa]

On the Form. In the AfterUpdate Event Procedure of the control where the first field is managed.

[danaluter]

Thanks you I keep getting a syntax error
me.First_Follow_Up_Date_on_Email_7_days = DATEADD("d",7,Me.Second_follow_up_Date_on_Email)

[NeoPa]

I see no obvious syntax error. Perhaps it would make sense to post the exact error message and number along with the code of the whole procedure this error is thrown up within.

Please don't forget to use the [CODE] tags when posting code as that's a site requirement. Every posting window has a button to add them to any selected text for you.

[danaluter]

Hi Thanks for replying...
the error now reads;
The expression After Update you entered as the event property setting produced the following error; Invalid outside procedure.
*the expression may not result in the name of a macro, the name of a user-defined function, or [event procedure].
*there may have been an error evaluating the function, event or macro

[PhilOfWalton]

Pure Guess: I would have thought you would have updated the First Field and calculate the second from it, in which case the code should be

Me!SecondDate = DateAdd("d",7, Me!FirstDate)
 

Sorry can't be bothered with your 35 letter field definitions. I'm a rotten typist.

Phil

[NeoPa]

Please refer back to my last post where I suggest you give the error message and number, along with the code of the whole procedure. One without the other adds very little to our understanding.

PS. The error message already posted indicates this is something quite different from a syntax error. Please try to be accurate with your information. That is critical. It avoids sending us off on wild-goose chases.

[danaluter]

Thank you , that was the issue I should have flipped the fields around.