display subform only when need

[datin]

Hi,
I have a form about staff dependants. I used subform for children
information. some of this kids got good results at school so I need to add
this information.I used subform for this information.I want this subform only
appear when i need but when i clicked the link, it showed the the blank
subform.the reason i do this because i dont want user see to many things at a
time.


i set form property Data entry : No
i used this coding to link the form
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Table1 Query subform"
DoCmd.OpenForm stDocName, , , stLinkCriteria

thank you and regards

 

[Chrisso]

Hi,
I have a form about staff dependants. I used subform for children
information. some of this kids got good results at school so I need to add
this information.I used subform for this information.I want this subform only
appear when i need but when i clicked the link, it showed the the blank
subform.the reason i do this because i dont want user see to many things at a
time.

i set form property Data entry : No
i used this coding to link the form
Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Table1 Query subform"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

thank you and regards

You can set the Visible property of the sub form so that it is not
visible. When you are ready for the user to see the sub form then
switch this property again.

Chrisso