subform invisible until main form field populated

[deb]

How can I make a subform invisible until the Project Field on the main form is populated?

Thanks,

 

[CT Witter]

On the main form, Select the Subform Control
Right Click and Select Properties
Change Visible to No

(This will make the subform hidden when first entering the form)

Then in the After update of your project field use:

Private Sub TextProjectField _AfterUpdate()
If Me.TextProjectField <> "" Then
Me.subform.Visible = True
Else
Me.subform.Visible = False
End If

End Sub

This code executes after you have updated the field and as long as there is text it will make the subform visible.

HTH,
CT