Tamar --
Why not simply check whether a given form is already open and bring it ot the top when the user tries to open it again?That would make sense in a general case, but not in my case.
In fact, all of the forms the user will be seeing are actually the
same form -- each form is created from parameters passed to it from its calling form.
For instance, the original form is usually "Summary by Class". The user might then select "Summary by Product Category for Class = Europe", etc. Each time the user "drills down" to a further level of detail, a new copy of the same form is invoked, but with different parameters.
Furthermore, once a form is created, the user may select which columns are to appear in the report (choice of about 50 right now). (This list of columns is inherited from the calling form.)
Jim
>>So, if I were to impose some limit to the number of open forms, what's a reasonable limit to use?
>>
>>And, secondly, how is it imposed? If the limit is, say, 100, do you have any suggestion as to what I should do when the user has 100 open forms and tries to open the 101st?
>>
>
>Rather than impose an arbitrary limit, why not simply check whether a given form is already open and bring it ot the top when the user tries to open it again?
>
>Tamar
Jim Nelson
Newbury Park, CA