Run-Time Error '94' - invalid use of null

[Solar.Paul]

We have a number of procedures which are called from a form via buttons which trigger events to call the procedures.

These have all worked well until we have changed the Window Mode of the form from Dialog to Normal (to enable scroll bars to show when the form won't fin on the screen). The form is opened by a macro and we changed the macro to open the form in Window Mode = Normal. The form opens correctly in the new mode (we have the scroll bars) using the information in the variable passed to it.

Running the procedures, however, results in Run-Time Error '94' - invalid use of null.

Can someone help with this please?

 

[MarkK]

Your best bet with code errors is post the code. Indicate at what line the error occurs. Wrap it in code tags--check out the number sign button, above.

private sub Test164391236
[COLOR="Green"]   'this code is easier to read and understand[/COLOR]
   msgbox "this is sample code"
end sub

private sub Test164391236
'this code is harder to read
msgbox "this is sample code"
end sub

 

[MarkK]

Hey, thanks for taking down that other one! Cheers,