Recalculate field after changing a textbox value

[jappe22]

I think it should be very simple, what i am trying to do...

I have a a calculated textbox which uses a formula (VBA) to calculate a numeric value.

One of the inputs of the inputs needed for that calculated field is textbox1. Default value = 0 and when i change it to 30 i want the calculated field to update immediately or at least after the focus of the textbox1 is lost.

Now it only updates the calculated field when i check another checkbox for example.

Anybody?

 

[PHV]

In the AfterUpdate event procedure of textbox1:
Me![calculated control].Requery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jappe22]

It helped, thanx, but u still have to hit enter in textbox1 before it updates the calculated field.

 

[rjoubert]

Try the On Lost Focus event.

 

[TheAceMan1]

How are ya jappe22 . . .

There's no way for access to know when you've finished data entry other than thru an event, which occurs when the focus is leaving the control. Events are:
[ol][li]BeforeUpdate[/li]
[li]AfterUpdate[/li]
[li]OnExit[/li]
[li]OnLostFocus[/li][/ol]
There is also an [blue]OnChange[/blue] event you can play with . . .

See Ya! . . . . . .