Updating a table from a form

[Lynn]

Hi Everyone,
I'm an access newbie...I built a form and one of the fields is called WaiverExpiry. This field displays an expiry date. When I was figuring out the date and keystroking the date into the field, the date would then appear on the appropriate table. Then I decided to let access do the math for me and I put in a calculation in the Control Source of the Waiver Expiry field. It looks like this:



IIF([Timeframe]="6 months",DateAdd("m",6,[DateOfCommunication],DateAdd("m",12,[DateOfCommunication]))

Where Timeframe and DateOfCommunication are also controls in the same form and the only two options are a 6 month or 12 month timeframe from the date of communication.
Once access started doing the calculation, the expiry date no longer appears in the table. I think it's because I no longer have the control source as "WaiverExpiry" but how do I make sure the new date populates the table?

Thanks,
Lynn

[pbaldy]

You are correct as to the "why". A solution:

http://allenbrowne.com/casu-14.html

[Lynn]

Awesome! Thanks so much, appreciate your help!
Lynn

[pbaldy]

No problem Lynn, and welcome to the site by the way!