Update column in table/forms

[sk88]

So I performed a update query for one of the new column that I added to the table. In my forms the rule was if A is updated, then B will be updated. This B is a calculation based on the rates of the given time period. Therefore, the rates could be different from month to month.



How do I perform a quick update to B? or a code to perform After Update event for A?

Now my B is not updated and stays blank.

Thanks

[June7]

Personally, I would save the rate or rateID and do the calc when needed.

Regardless, code in field A AfterUpdate event to set value of field B.

Me!B = something

Exactly what is A?