I’m assuming that you want it to update automatically instead of a button? Use the wizard to make an after field change event like shown here. You can add more of your own case statements to capture all of the fields that you want it to watch, then call your method.
Edit: and actually you can probably just key off of on of the total fields, like “PriceTotalProfit” because that one will change when any of them changes.
And it looks like the wizard will add the extra fields for you.
I should have phrased that differently. I have it working, but not the way I intended to have it work initially. I will be setting up the form events now but wanted to share that I do have a working code.
I may just have to look into that. I do have the form events setup but it only seems to be working about 98% of the time. Occasionally I’ll still run across one that somehow didn’t get captured.
