Form does not appear

[GP]

I have a form which runs some code (takes a few minutes) so I opened another form which displays a counter of records. But this form only partially appears, the title and record counter as it is refreshed, the rest is just white.

How do get the form to display properly?

 

[missinglinq]

Why would you want to open a second form? Why not have the counter appear on the first form? If you don't want it to show before you run the code or after, you can just turn the visible property off and on as you want.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[Rolliee]

I like the use of second open forms, especially when the second holds unbound fields that I want to check before incorporating in the main field. I have always found the second to open nicely and on the DoCmd.Closse, the first is right where I left it.

rollie@bwsys.net

 

[missinglinq]

That may be Rolliee, but if understood GP's post correctly, he is using a second form simply to display a progress bar to show the number of records as they are being processed. A second form to display a single control is quite an overkill. Why add they overhead for one control, especially when the processing being done takes a number of minute? Kinda goes against one of the cardinal the rules of programing; keep things as simple as possible.

A second form to show a number of controls, as in the case you cited, could quite possibly be appropriate. But that's not the case here.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[GP]

My first form is a selection screen and the user clicks OK to generate something.

I like the second form to open up becuase my users would worry if the first form was still displayed with a counter.

I have now solved my problem

firstform.visible = false

then in each loop:
secondform.repaint