Reloading a Form

[Brandr]

There comes a point in my error handleing where if error 70 appears I have to reload my form.

I'm currently using a statement like this:

If Err.Number = 70 Then
MsgBox "Database Access/Load Error"
Unload SCS
Load SCS
SCS.Show

And I'm wondering if there is a more professional way of reloading a form short of unloading it then loading it again (plus the flikcer that is the result of my form unloading then loading looks bad!)?

Thanks,
Brandr

You can shorten it a little by removing Load SCS.

If Err.Number = 70 Then 
    MsgBox "Database Access/Load Error" 
    Unload SCS  
    SCS.Show
End If

[Brandr]

But Is There An Aucutal Command for Reloading a Form. I don't like the way the program flickers when the form is unloaded and then loaded again. Is this even stable in runtime?

[parksie]

When you unload the form, by necessity it has to be hidden, so no, there is no way round the flicker. A better alternative is to work out what is reset when the form is reloaded, and set it up again with the same instance.