After Insert macro not functioning

[scottnew2ac]

I'm trying to calculate a numeric value of a field based on the value of another field as a row is created using an "After Insert" macro. To test this I've created a table which has two integer columns "NUMBER1" and "NUMBER2". The macro was defined using the wizard as:

 EditRecord
            SetField
               Alias
               Name  NUMBER2
               Value = 5+[NUMBER1]
          End EditRecord

NUMBER2 is not populated when I enter a value in NUMBER1
I get the following in USysApplicationLog:
Error Description
-20335 EditRecord failed because the default alias represents a record which is read only.

[tanvi]

I read this issue on many forums & found it is hard to solve. Read this:
http://blogs.msdn.com/b/access/archi...-triggers.aspx
You cant use after update to update the record you need to use before!!

Ref: http://answers.microsoft.com/en-us/o...b-5c08fd159df7

[scottnew2ac]

Thanks, using "Before Update" resolved the issue, though having to focus on the field then tabbing over it wasn't quite how I invisioned this working. But I at least understand what's going on. Thanks again !!!