Make field on subform not visible

Kila

Registered User.
Local time
Today, 15:31
Joined
Mar 5, 2003
Messages
275
I have a form with a subform. I would like to make a field on the subform not visible if a field on the primary field is null. Can anyone help? Thanks.
 
In the appropriate event:

Private Sub cmdApply_Click() 'or some such....

If IsNull(Me!MyMainFormControl) Then

Me!SbFrmControlName.Form!MyControlNameOnSbFrm.Visible = False

End If

End Sub

hth,
 

Users who are viewing this thread

Back
Top Bottom