Keep code out of the Load event and put it in a Public form function:

Load Myform
Result = Myform.OpenFunction
If Result = Fail Then
Unload.Myform
Else
Myform.Show [vbModal/vbModeless]
End if