Form Event Procedure Help

[bkatsma]

I'm having some trouble coming up with a solution. I have three fields (generally entered in this order); Actual_Hours, Billed_Hours & Billed_Amount. I'm trying to get them working together, to establish a starting point, when Actual_Hours is entered.

I was able to auto fill Billed_Hours from Actual_Hours using the AfterUpdate event. So if I put in (5) for Actual_Hours, Billed_Hours updates to (5) as well. Here is my problem. When (5) is automatically entered into the Billed_Hours, I'm looking for Billed_Amount to automatically update as well to Billed_Hours * 25.

The below code 'works' if I change the Billed_Hours, but I'm looking to do it automatically.

Private Sub Billed_Hours_AfterUpdate()
Me.Billed_Amount = Me.Billed_Hours * 25
End Sub

 

[ranman256]

Seems to me, billed amt should never be saved. It is always calculated in a query.
In a form, again it is a calculated field using the propery, not an event.

 

[bkatsma]

I took your advice. I now am using a calculated query to handle, thanks!