VB to load a form

[gmazza76]

Good Afternoon,

I normally use the following code to load a userform

Sub Group7_Click()
   
    query.Show
   
End Sub

This has worked numerous times but i am now getting a "run-time error'424' Object required. erro and i dont know what this means.

Any help would be great.

Cheers

 

[Tuelor]

Has the perform been recently renamed?

I would also rename the form to frmQuery to make obvious what type of object you are referring to.

D

 

[Glory]

It could be a lot of things. If anything goes wrong in the userform initialization event or if there's any kind of syntax or object-oriented error in the userform object module there's every possibility the code will error out at the "Userform.Show" statement in the standard module you use to show the form.