Global / public variables are essentially the same thing. These should only be declared in a standard/class module - not a form/report module.
Variables in forms/reports are specific to that object so should be Private. Use Dim to declare these
Agree with Micron's comments regarding On Error Resume Next. I also recommend avoiding its use in your apps.