How to forbid opening subform

[samotek via AccessMonster.com]

Can i forbid opening the subform by itself ? I want my subform to be opened
only by the main form and i somebody wants to open the subform not to allow
it

 

[Rick Brandt]

Can i forbid opening the subform by itself ? I want my subform to be
opened only by the main form and i somebody wants to open the subform
not to allow it

Try referring to the subform's Parent property in the Open event. When NOT
opened as a subform that will raise an error. You can then have an error handler
that cancels the Open event.

Private Sub Form_Open(Cancel As Integer)

On Error GoTo ErrHandler

Me.Parent.Name

Egress:
Exit Sub

ErrHandler:
Cancel = True
Resume Egress
End Sub