Userform fully functions when I run it from the run tab in developer but when I open a new document from the template the form doesn't automatically show. I have the form code:
Code:
Option Explicit
Private Sub Userform_Initialize()
End Sub
Private Sub cmdSubmit_Click()
Select Case ""
Case Me.txtContactName.Value
MsgBox "Please fill-in the full name of the contact for the group."
Me.txtContactName.SetFocus
Exit Sub
….etc (all runs great)
and This Document code simply:
Code:
Private Sub Document_New()
FRM_room_block.Show
End Sub
My form is called "FRM_room_block" obv.