refreshing screen

  • Thread starter Thread starter CW
  • Start date Start date
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
 
There are important differences between Repaint, Refrash and Requery.
Repaint does a repaint of the actual window with controls - thats all.
Refresh does a refresh of the data shown - that is - it refreshes values for
each control.
Requery does a requery of the underlaying SQL and updates the data in the
form and controls.
 
Back
Top