K Kila Registered User. Local time Today, 15:31 Joined Mar 5, 2003 Messages 275 Mar 17, 2005 #1 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.
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.
D DALeffler Registered Perpetrator Local time Today, 14:31 Joined Dec 5, 2000 Messages 263 Mar 17, 2005 #2 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,
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,