Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform Loading (Access 2K)

    I'm trying to prevent a subform from loading on a multitab form, except when the tab is chosen for view. Any suggestions. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subform Loading (Access 2K)

    Don't populate the default sourceobject of the subform control. Instead, use the change event of the tab control to test which page is being selected and then if it is the page in question, check to see if the sourceobject of the control is an empty string. If it is, set it to the name of the subform being used to populate the control. Once the subform control is populated, you can leave it alone. Be sure you leave the master and child link fields set by default. They are ignored anyhow if there is no sourceobject set.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •