run a query after record is added or changed

[barbola]

I have a continuous subform (Sub2) where a user enters records that are adjustments to records in another subform (Sub1).

After the user enters a record in Sub2, I want to run a query that will compare the new record to the original record, and update a value in Sub2 table.

THe query works but I just don't know how, when or where to call it to run after the record is entered in Sub2.

 

[Remou]

How about the After Insert event?

http://lessthandot.com

 

[barbola]

Thanks. I did find that, and it works perfectly!