I have a form that has one field that is determined by a query; it is a price that updates based on the selection of a different field. When you change the selection, this field changes accordingly.
However, in this same form, I have a field that is set and puts the firm value in a field in a table; it is determined by using an Event Procedure in the AfterInsert of the form itself.
Private Sub Form_AfterInsert()
Me!PriceEach = Me!Price
This works great unless the original field gets changed, it won't automatically reset to the new value. Is there any way to set this?