Display data in a control

[Rats]

Hopefully a simple one that is eluding me at the moment.
I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will only display the answer if I go into another field on the form and make a modification to the data. It seems that the control will only calculate on an after update event but I need it to be visible at all times when the form is open. I have tried requery on open and on load with no effect.
Any thoughts out there?

Thanks

 

[seth_belgium]

And is this control-filling actually triggered by an AfterUpdate-event?

If so, you could add the same code to the Form_Load-event. That will make the filling-in happen when you open the form. However it won't when you go to another record. A possible sollution for that might be building custom navigation-buttons with that piece of code behind them.

Seth