Updating a text box based on another text box

  • 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.
 
Have you tried :

Me![controlName].refresh

Where [ControlName] is the control you want refreshed.

Dave
 
Yes, I tried that. I get:

"Object doesn't support this property or method"

Steven


Dave said:
Have you tried :

Me![controlName].refresh

Where [ControlName] is the control you want refreshed.

Dave


ExcelMan said:
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.
Click to expand...
Click to expand...
 
-----Original Message-----
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.


.
Click to expand...
 
Back
Top