-----Original Message-----
Hi. I have 2 fields: DateOfLastRenewal and DueDate.
DueDate = DateOfLastRenewal + 2 years.
How can I get DueDate to automatically populate?
Set its ControlSource to the expression
=DateAdd("yyyy", 2, [DateOfLastRenewal])
Note that, because this is a calculated value, it won't be stored in
your table. So long as it can be calculated from DateOfLastRenewal
whenever you need it, there's no need to store it. If there's some
reason you need to be able to update it independently, though, then
another mechanism must be used.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.