Refreshing a text box based on other text box values

  • Thread starter Thread starter ExcelMan
  • Start date Start date
E

ExcelMan

I have a simple form with a number of bound fields with text boxes. I also
have an unbound text box.

The unbound text box takes on a calculated value that is a concatenation of
several of the other text boxes.

The problem is that the unbound text box only updates when I exit a bound
text box and change records. I want the unbound text box to update with
every keystroke that changes a referenced bound text box.

I am able to get this to work by placing the command:

Me.Refresh

in the bound text boxes Change event. However, this makes the screen flash
and is slow. Obviously it is refreshing the entire form instead of just
updating the unbound text box.

Does anyone know how I can specifically recalculate the value in the unbound
text box when the user is typing in one of the referenced bound text boxes?

Thanks in advance.
 
do someting like that:
Private Sub YourBoundedField_On Change()
Me.yourUnboundedField.refresh
end sub

I hope that will help. Othervise You will need help from more clever
participants here

Regards,
dk
 
Back
Top