How to erase an array of Menus

[paralinx]

Hey all,

How can I go about errasing an array of Menus name mnuArtist? This is what I tried

Erase frmMain.mnuArtist

But it gives me the error of "expected array"

How can I do this?

[RhinoBull]

If it is control array then you have to use Unload statement:

Dim i%
 
On Error Resume Next
 
Form i = mnuArtist.LBound + 1 To mnuArtist.Ubound
    Unload mnuArtist(i)
Next i

NOTE: you CANNOT unload any member of control array that were added in design - only those that you added using Load statement at runtime.
It was presumed that only ONE instance was created in design and rest of them at runtime so that's why you will see mnuArtist.LBound + 1 in the loop.