Real-time update using DLOOKUP

[imdl]

I used DLOOKUP for a text box in a form. However, to see the looked-up value, I still have to close and reopen the form. Is there any way to show the looked-up value in the text box by just a mere click? Say for example, I hit the "enter" or "tab" key, the text box would automatically update.

 

[SOS]

Putting the code:

Me.Recalc

will do the job (could be in a click event, or some other event).

 

[imdl]

great, it works! tnx a lot!