Auto calculate a field

[Guest]

I have a form with the control source
=[txtPr]*[txtImpact]/100

When I tab to another field it calculates correctl. What we need is when a
user enters a value in the field the value above automatically change
without tabbing to next tab.

Thank you

AL

 

[fredg]

I have a form with the control source
=[txtPr]*[txtImpact]/100

When I tab to another field it calculates correctl. What we need is when a
user enters a value in the field the value above automatically change
without tabbing to next tab.

Thank you

AL

If you enter a value in the control, you must at least exit the
control and go somewhere, otherwise how would access know that, if you
enter a 4 you are not wanting to enter 45 or 456?
If you don't want to go the 'next tab', whatever you mean by that, you
can use the tab order to exit to a different control on the form, or
use the control's AfterUpdate event to set focus to a different
control, or change the Form's cycle property to Current Record.