C
CW
I have a main form that update fields in the subform. Unfortunately, the
subform screen does not update itself, on screen, unless I click onto the
individual fields on the subform.
Now it's not a requery problem, because all I have to do is to alt-tab to
another screen, and alt-tab back, and the changes would be shown on screen.
Obviously it looks to me that it somehow has not refreshed the screen
(rather than data not being refreshed).
I don't want to use requery method (as it can take quite a while and is
fairly memory intensive). I can use refresh methods. However, given the
number of fields in the subform, it is certainly not an elegant solution
either.
I have tried repaint method on both the main as well as the subform, and it
has made no difference. Any idea what I need to do to get the screen to
update itself short of calling requery/refresh?
Thanks in advance
subform screen does not update itself, on screen, unless I click onto the
individual fields on the subform.
Now it's not a requery problem, because all I have to do is to alt-tab to
another screen, and alt-tab back, and the changes would be shown on screen.
Obviously it looks to me that it somehow has not refreshed the screen
(rather than data not being refreshed).
I don't want to use requery method (as it can take quite a while and is
fairly memory intensive). I can use refresh methods. However, given the
number of fields in the subform, it is certainly not an elegant solution
either.
I have tried repaint method on both the main as well as the subform, and it
has made no difference. Any idea what I need to do to get the screen to
update itself short of calling requery/refresh?
Thanks in advance