Multiple forms

[zrzr]

Hi guys !!!

I have so many forms in my application that I decided to write a function to kwnow what form to show for each case (I don't know the english for this : maybe form handler)

To perform it, I open all my forms as acDialog, so that VBA code is freezed until the form is closed.

This is my problem :

I have three forms : Form1,Form2,Form3
In my code, I open Form1, and I want to open Form2 without closing Form1.So I open Form2 from Form1, as a acDialog.
But when I close Form2, the code follow and open Form3, whereas I did't close Form1

I know my explanation is not really clear, but can you :
- tell me why the code follow
- tell me how to prevent this
- give me a better solution if you have it !!

Thanks in advance

 

[dpimental]

You might want to write a couple of functions.

1. To open a form.
It should take the form name as an argument.
This would allow you to open any form from any other form.

2. To Close a form.
Same as above.

David Pimental
(US, Oh)
dpimental@checkfree.com