screen movement

[JohnE]

I have a module with a Public Sub and Public Function. On a form I have a
button on a form that calls the Sub and Function. But, when I do, the screen
begins flickering and I see the outline of the forms opening and closing. It
has been awhile but isn't there a line I can use that doesn't show the
flickering of the different screens opening and closing?
Thanks.
John

 

[Klatuu]

Don't know what you might be doing that would be opening and closing all
those forms, but you can use the Application.Echo False to turn of screen
updating while you are doing that and setting it to True when you are done.
I would also avise you to have an error handler in the process that are doing
this so you can turn it back on if you get an error.

 

[Dirk Goldgar]

I have a module with a Public Sub and Public Function. On a form I have a
button on a form that calls the Sub and Function. But, when I do, the
screen
begins flickering and I see the outline of the forms opening and closing.
It
has been awhile but isn't there a line I can use that doesn't show the
flickering of the different screens opening and closing?

What are you doing when opening and closing all those forms? If you really
need to open and close them all, you may be able to specify when opening
each form that it's to be opened hidden. It's one of the options for the
WindowMode argument of the OpenForm method. For example,

DoCmd.OpenForm "frmMyForm", WindowMode:=acHidden