how to hide subforms from a form 1

[tatika]

I created a subform w/some confidential information that I would like to share only w/a group of users.
I don't want the information to display unless it is the right user.
Is there a way to hide a subform and enable it on click. Could you let me know how?
thanks

 

[jksmi]

Hi, you can use the subform visible property to acheive this - set the sub form visible to no (make sure that it says subform/ subreport in the properties title so you know you're changing the property of the subform control not the underlying form) then, say on the detail double click event, put something like...

Private Sub Detail_Click()
Me.Controls.Item("Child0").Visible = True
End Sub

of course anyone can do this so you'd need some other code if you want to check if this person should be able to view it... HTH, Jamie