Making forms invisible

[Lanason]

Not the most elegant programming I know - but I'm opening forms to get data then closing using VB code.

Is there a way to stop the screen showing these forms as the code runs

something like Display refresh off then display refresh on.

Just to hide my workings from the masses

 

[essaytee]

Not the most elegant programming I know - but I'm opening forms to get data then closing using VB code.

Is there a way to stop the screen showing these forms as the code runs

something like Display refresh off then display refresh on.

Just to hide my workings from the masses

Check this link.

The 7th parameter of the OpenForm method is WindowMode. When opening the form use the constant, acHidden. Caveat, I've not tested this, I'm assuming the form will in fact be open but not visible. To make the form visible use the visible property of the form, set it to true.

If it's only data you need to retrieve there are easier ways to achieve this; probably the subject of another thread.