Unload a userform

[mikeosborne]

I have a user form that has a toggle button which activates(shows) another userform with the following code

Private Sub tglSubLog_Click()

fmSubLog.Show

End Sub

and laters acts as a condition check in my code. In the second userfrom I have a command button for Cancel which has code in a commandbutton_Click routine.

Private Sub cmdCancel_Click()
'close fmSubLog
Unload Me
'reset Insert Submittal Log toggle button to false
fmSheetBuilder.tglSubLog.Value = False

End Sub

in order to to completely close the userform with this as the cancel code I have to hit the cancel button twice.

if I write that same code like this;

Private Sub cmdCancel_Click()

'reset Insert Submittal Log toggle button to false
fmSheetBuilder.tglSubLog.Value = False
'close fmSubLog
Unload Me

End Sub

I get a "Runtime error 400: Form already displayed; can't show modally." I understand what is happening in the code it is looking at the change to false under the cancel code and reading that as a click it and trying to show the userform a second time.

Now this was working fine last week, today it is not, how can I fix this.

[Ed Jobe]

In the first format of cmdCancel, after you unload the form, nothing beyond that is going to execute. So setting the value on the other form didn't cause an error.

As to your second scenario, a change to false can't cause the Click event to fire. It could only fire an onChange event, but I don't recall if a button has such an event. The problem is that you can't access a form while its in the background and a modal form is active. Its the same as if you clicked outside the form. Windows would play that nice thunk sound. What you need to do is place the toggle code right after you you show the form. This is where code execution returns after the form is closed.

[mikeosborne]

THank you for the input I figured out what I needed to add to accomplishe my goal about 2 minutes before you replied to my post.