Add a default value to a field

[brag89]

Help

I have a Table called Contract that uses a form called AddContract to add records. There is a field on the form that asks for a FridgeHours. What I want the form to do is if the FridgeHours field as a value above 0 then another field called ExcessCost would have a default value added to it. At the moment I am having to do this manually.

Thanks

Brag

 

[Jack Cowley]

In the After Update event of FridgeHours put code like this:

If Me.FridgeHours >0 Then
Me.ExcessCost = TheValueYouWantInTheExcessCostFieldGoesHere
End if

hth,
Jack