Closing Userform causes another form to close (crash)

[quackdad]

I have a Userform which, when an item in a ComboBox is selected, brings up another form. This 2nd form is be filled in and closed, returning to the original form. When item A is selected, form A comes up and closes with no problem. When item B is selected, form B comes up and crashes the original form when it is closed. Is there something I can do to prevent this from happening?

 

[Logit]

Do you have both forms loading Modal = False ?

 

[quackdad]

This a project I've worked on for several years, making "improvements" from time to time - which means I don't always remember why I did what I did. All forms are set to ShowModal = True, but the first Form is loading as = False (i.e., 1 is False, 2A and 2B are True).

 

[Logit]

What happens if both are ShowModal = False

 

[quackdad]

That seems to do the trick. So does making everything Modal = True. I will need to test over the next couple of days, so watch this space, just in case (please). No news will be great news.

 

[Logit]

Glad it worked.