Microsoft Access AfterUpdate Events
Change Values, Run Events, Do 'Stuff' when a Field is Changed
Q: I have two fields on my form (HourlyRate and
HoursWorked) and I need to calculate a billable service charge by
multiplying them together and placing that value in a 3rd field
(ServiceCharge). I need to be able to also just type in a ServiceCharge
value or adjust it, so I can't just use a calculated field in a query.
How can I do this?
A: You can use an
AfterUpdate Event in both the HourlyRate and HoursWorked fields so
that when they're changed, the ServiceCharge is automatically
calculated. You can do this with a very simple one line of VBA
code, as long as you know where to put it.
Here is a FREE VIDEO TUTORIAL
that will walk you through an example of building an AfterUpdate
Event. It's
much easier to show you how it's done than to explain it here.
I teach the concepts in this free mini tutorial in my
Access 303 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
| 
