opening a subform

[badrack]

I was wondering if there is any way to not open a subform when the main form is opened but have it open after a record is created. Is this possible or do I need to make it a seperate form and tie it together with a macro?

 

[Terpsfan]

Try these two code snippets. The first hides the subform when you open the main form. The second makes that subform visible when you add a new record. It worked for me.


Private Sub Form_Open(Cancel As Integer)
Me!Subform.Visible = False
End Sub

Private Sub Form_BeforeInsert(Cancel As Integer)
Me!Subform.Visible = True
End Sub

 

[badrack]

Omega, I tried your code substituting Me! with TBL_TENSILE but it gives me a variable not defined error. How do I define the variable in Visual Basic?