display subform only when need

  • Thread starter Thread starter datin
  • Start date Start date
D

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
 
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
Click to expand...

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
 
Back
Top