Object required Error

[jsambrook]

Good Morning all!
I am trying to launch a form, which I had working successfully and cannot work out for the life of me what I have done to break it. I cant even get it to launch the form, it comes up with Object Required and it highlights the row NewStaffForm.Show of the macro

Private Sub CommandButton1_Click()
NewStaffForm.Show
End Sub

My Form is definitely called NewStaffForm
Anybody any ides what I'm doing wrong?

 

[jsambrook]

All sorted and working great! Thanks so much guys!
One more quick question. Once the info has been inserted into form, how do I get the form to close without pressing cancel? O do I just use the unload me at the end of the code?

 

[Ruddles]

Sorry for being a total dunce, but how do I add option explicit? simply write it?

Yes, simply place those two words on a line on their own as the first line of the module.

In VBA, go Tools > Options > Editor, and tick Require Variable Declaration, then VBA will insert it automatically in every module you create.