Wait while form renders

[SFAxess]

If I am reading your process correctly, the user clicks a
button on a switchboard which opens a form (call it
FormA). FormA has code in its Open or Load event that
runs an time intensive query. Once the query is done,
FormA closes and the data entry form appears.
If this is indeed your process, I would suggest the
following:
1) When the user clicks your switchboard button, have it
launch Code not a form.
2) Within the code: open FormA, run your query, open
FormB, close FormA-- in that order.

That should do what you want. You may want to make FormA
a pop-up and modal as well.

 

[Todd Lemen]

Thank you! Here is the sequence that I found to be
effective:
Open FormA
Close Switchboard
Repaint FormA
Run Query
Open Form B
Close Form A

I did find it necessary to repaint FormA. Without the
repaint, the previous screen image (in this case, the
Switchboard) appears in the detail section of FormA, as
if FormA were an image mask...

TL