Cancel close make form invisible

[Ruegen]

Hi everyone



I have made a form which I want the staff to only make visible on close instead of closing the form so in the unload event I have made cancel = true and then the form.visible = false

this way when they click to open the form all I do is put the form to .visible (and it stays open the whole time even when they think they have closed it)

This helps with loading speed from their view - however.

When I have made the form invisible it is still open. I go to right click into design view and... nothing happens. The form won't be visible in design view.


Is there a way around this? Have I missed something?

[Ruegen]

sorted with this code in the unload

If Me.CurrentView = 1 And Me.Visible = True Then
Cancel = True
Me.Visible = False
End If

[Ruegen]

and this in the form load

If Me.CurrentView = 1 And Me.Visible = False Then
    Me.Visible = True
End If