Updating calculate control as you type? 2

[djayam]

Hi all,

I have a control "Quantity", a control "UnitPrice", and a control "TotalPrice". In the AfterUpdate of "UnitPrice" I have "TotalPrice" = "UnitPrice" * "Quantity". Works no problem. I wondered, however, if there was a way TotalPrice could be recalculated with every key-press in UnitPrice so it updates "as you type".

Anyone know how?

Cheers,

Jason

 

[ZOR]

Heve you tried the onchange event of a control? Regards

 

[TheAceMan1]

How are ya djayam . . .

Agree with ZOR on use of the [blue]OnChange[/blue] event. You'd caputre input thru the [blue]Text[/blue] property of the control, convert to numeric and perform the calculation.

[blue]   Me!TextboxName = Val(Me!UnitPrice.[purple][b]Text[/b][/purple]) * Me!Quantity[/blue]

[blue]But what would be the point of this?[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[MajP]

Something like this.

Private Sub txtUnitPrice_Change()
Me.Recalc
End Sub

Private Sub txtQuantity_Change()
Me.Recalc
End Sub

 

[djayam]

Perfect - thanks ZOR and AceMan. Not an essential feature AceMan but I know the client and it'll go down well.