Open same form 2 or 3 times

[MrDeej]

Hello!

I have a form which fills with information with the "on open" event based on
some criteria i set. I want to open more instances of this form, which is
unbound, in my Access 2007 database.

Is this possible?

 

[Allen Browne]

Yes. You can use the New keyword to open multiple instances of a form.

The more involved aspect is handling the lifetime of the variabes that
represent each instance. Here's an example of how it can be done:
Managing Multiple Instances of a Form
at:
http://allenbrowne.com/ser-35.html

There's a sample database link at the end of the article.
The A2000 one will work in A2007.