Refreshing a text box based on other text box values

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


"ExcelMan" wrote in 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.

Hi ExcelMan.

I would try adding the line 'Me!ListBoxyouwantupdated.Requery' in the 'After Update' event property of the entry part of your form. (the "Me' may be uneccessary). 'Requery' has worked fine for me.. never used 'Refresh'.

regards Laurie Eaton

"ExcelMan" wrote:

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.