Originally Posted by
Mike4172
...it doesn't auto fill it in immediately when I click the tab button after entering in the number like previous access 2000 version...
- What 'tab' button are you talking about?
- Where do you currently have your code?
- What kind of Field is Pawn defined as, a Number Datatype?
If your results depends on the Value that is entered in a given Control, place your calculation in the AfterUpdate event of that Control. If I've understood your explanation correctly, and you're talking about
- Entering the 100 you mentioned in the AmtFin Textbox
- And the target Field for the calculation results were named InterestField
- And you only want the calculation done if Pawn = 1
Code:
Private Sub AmtFin_AfterUpdate()
If Me.Pawn = 1 Then
Me.InterestField = Me.AmtFin * 0.25
Else
Me.InterestField = 0
End If
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007