AfterUpdate not firing

[newvb]

Hi - Two of the fields in my table are called Beginvalue and EndValue.


The first thing that I do on the form is to make the EndValue of the last record the new BegValue (bound field) on the form. I have a query which gets the previous record from the table, and I run a DLookup against the query to get the last EndValue. This is entered into an unbound field (getBeginValue). In the AfterUpdate event of getBeginValue I use the code Me.BegValue = the last end value in the unbound field. The BegValue is not updating. I tried to fire the AfterUpdate from the next field on the form by using using the Call getBeginValue_AfterUpdate, but that is not working. (For a different field on the form I got the AfterUpdate to fire to update the field with a calculated value.) I'm stumped, and would appreciate some help on this. Thanks.

[RuralGuy]

Is your db in a Trusted Location? http://www.btabdevelopment.com/ts/2010TL

[newvb]

Yes it is.

[newvb]

I was looking through my database and discovered that there were some blank fields for the BegValue, which I filled in. Now the BegValue on the form is updating with the previous EndValue. So, no update because there was no previous value in the table to update with. Thanks for responding to my post.

[RuralGuy]

That's great! I marked this thread as Solved for you.