Echo? Repaint? or something else??

[Rick Allison]

How do I stop a form from blanking out?

I have an unbound form. I populate it by running multiple queries to collect data. I then populate all the controls on the form.

What's happening, is while I'm collection data the form goes blank. The form is still visible but all the controls disappear.

I've tried Application.echo false and docmd.echo false and neither affect the form. It still goes blank when I go off to collect the data before showing.

What I want is for the form to remain as is and when all the data has been collected 'snap' into place, if you will, with the new data.

Is that possible and if so what command does that?

Thanks,

-
Rick Allison

 

[Graham R Seach]

Rick,

Try periodically issuing DoEvents.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


How do I stop a form from blanking out?

I have an unbound form. I populate it by running multiple queries to collect data. I then populate all the controls on the form.

What's happening, is while I'm collection data the form goes blank. The form is still visible but all the controls disappear.

I've tried Application.echo false and docmd.echo false and neither affect the form. It still goes blank when I go off to collect the data before showing.

What I want is for the form to remain as is and when all the data has been collected 'snap' into place, if you will, with the new data.

Is that possible and if so what command does that?

Thanks,

-
Rick Allison