It's good idea to set the pointer for the whole screen.

In a CommandButton (In Form1)
Code:
Screen.MousePointer = vbHourglass
Form2.Show
In Form2's Load event
Code:
Screen.MousePointer = vbDefault