Repainting a Form

[ortaias]

I have a form which calls up a second form for purposes of data entry.
When closing the data entry form and returning to the main form, things
don't work as expected.

When I return to the main form, I trigger the on acitvate event to run
a macro. I can use the Dlookup function to update my fields, which is
OK. However, I intitially tried to use the Repaint Object command to
repaint the form. That did not work. Though I solved the problem with
Dlookup, I would like to know why Repaint Object did not work?????

 

[Allen Browne]

Repaint just forces the screen to be written again.
It does not force the calculated controls to be recalculated (Recalc).
Neither does it force a bound form to reload all its records (Requery).

 

[ortaias]

Thank you very much. You have a very good website. I was able to get
a lot of information off of it.