Hi, all:
I hope you can help this VBA newbie. It's probably rooted in my lack of understanding and experience with Access events.
I realize that I should not store a calculated variable such as mileage cost (miles * rate) in my cost table. So I am storing Mileage and MIRate (with a default value).
My form, based on an all-fields query of my cost table, defaults to datasheet view. I would like to display a message box to appear immediately after the user enters mileage so the user can confirm the calculated mileage costs. So I created an afterupdate event:
Private Sub Mileage_AfterUpdate()
MsgBox prompt:="Mileage costs = $ " & Mileage * MIRate
End Sub
Nothing happens. It won't popup on before update or on change What must I do to get the msgbox to appear? Thanks!