subform question

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

Hello. I have a main form that has a tab control on it. The first tab has
the parent information on it. The tab also has a subform on it that shows
the children. My dilemma is when the form is opened the child information is
visible for first record. What I would like is for the subform to be empty
until the parent is selected from a listbox that is on the tab. When the
parent is selected from the listbox, the parent information fills in then the
subform springs into action and displays the appropriate child records.
How can I get the subform to display nothing until the parent is selected?
Thanks.
.... John
 
John

Try hiding the subform (.Visible property) until your user selects the
parent record. Make it visible in the AfterUpdate event of the list box.
You can draw a rectangle to "hold" the space if your form looks empty
without the subform. Hide the rectangle at the same time you unhide the
subform.
 
Scott, thanks. I "played" around with it some and did some coloring with the
rectangle and it doesn't look obvious the subform is being unhidden/hidden.
Thanks again.
.... John
 
Back
Top