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.