[AccessD] White screen

[Stuart McLachlan]

Do you have parent/child links between the form and subform?

Where is your Form_Subform.requery triggered, what exactly is the code that does this?

>From your description. the requery is being called repeatedly - you should be able to monitor 
the connection in SQL Serv Management Studio to confirm this.

What happens if you build a simple query to a single temporary local table and try exactly the 
same process with that?



>               On the subform 6 lines are slowly populated, 2 seconds
>                 per line. Then, the subform blanks, and it slowly
>                 repeats 22(!) times
>               # Interestingly, code that executes after the Requery to
>                 populate another field is executed immediately after I
>                 press the button to populate the subform, while the
>                 first record on the subform is slowly filling.
>               # After the subform seems populated it still isn't
>               ready.
>                 If I click on the main form a couple of times the
>                 whole form gets a whitish overlay (the "white screen"
>                 in my subject) and I can no longer get to the open
>                 code window.
>               # After the form can be used and I close it the form is
>               no
>                 longer maximized and the subform begins to populate
>                 again, filling 6 lines slowly, before it finally
>                 closes.
>   * Things I've tried that haven't worked
...