Dear Richard
My problem; When I recieve a letter, its date will be data in column "first date". "Second date" will then be "first date + 10 days .. "third date" will be second date + 10 days ..and so on for the next 4 columns - So far so good -:-)

If I answer a letter before 10 days, I would like to enter that date in "Second date" and "third date" .. "Fourth date" etc should aoutoupdate related to the newly entered value.
It can do the first autofill, but then.. I am not able to enter a new value ... ? Do you have an idea.

I am a newby .. but have copied small lines of code into the VB editor to make my database open/close and search data out in tables

best wishes

---

Answer from Richard Rost:

Reno, I assume that you're using a query with a calculated field to automatically fill in the SecondDate field so that it's:

SecondDate:FirstDate+10

What you need to do instead is to make a FORM where you have an AfterUpdate event for the FirstDate field that sets the value of SecondDate in VBA code. This way you can CHANGE it later if you want to, instead of relying on a calculation to do it for you on the fly.

This tutorial will explain how to do that:

You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things.

The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL the update if the data is not valid. AfterUpdate runs after the data is saved to the table.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create an AfterUpdate event:

http://599cd.com/tips/access/afterupdate-event-vba?key=BlFAlEx