Refer to Subform

[CC]

I want to hide the subform on a main form until the user enters a date.
Using the code below I get the Run-time error 424 "Object required" Can
anyone debug my code:

If Forms!Frm_EnterRenewalsReceived!ReceivedDate Is Null Then
Forms.Frm_EnterRenewalsReceived.SubFrm_RenewalsReceived1.Visible False
End If

 

[Damon Heron]

If you are on the main form, the current event code would be:

me![SubFrm_RenewalsReceived1].Form.Visible= Not IsNull(me!ReceivedDate)
end sub

 

[Mr. B]

Hi, CC.

Give this a try:

If IsNull(me.ReceivedDate) Then
Forms!Frm_EnterRenewalsReceived!SubFrm_RenewalsReceived1.Visible = False
End If