Reloading a Form

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.

Code:

---

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

---

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?

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.