Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUBFORM IN TAB CONTROL (2003)

    i HAVE A SUBFORM WHICH RESIDES IN A TAB CONTROL(PAGE) ON A FORM. I WOULD LIKE TO BE ABLE TO REFERENCE ONE OF THE CONTROLS IN THE SUBFORM TO A TEXT BOX ON THE MAIN FORM. I CAN'T SEEM TO FIND THE RIGHT SYNTAX

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUBFORM IN TAB CONTROL (2003)

    Please check your CapsLock key! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    The tab control does not come into this, you don't need to include it when referring to controls. If you want to refer to a control on a subform, you can do it like this:

    =[SubformName]![ControlName]

    where SubformName is the name of the subform as a control on the main form and ControlName is the name of the control on the subform. The name of the subform as a control is not necessarily the same as the name it has in the database window. To find it, open the main form in design view and click once on the subform. Don't click on it a second time, for that would select something in the subform. The control name can be seen in the caption of the Properties window, and in the Name property in the Other tab.

    See Forms: Refer to Form and Subform properties and controls on Dev Ashish's Access Web for a comprehensive overview.

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUBFORM IN TAB CONTROL (2003)

    As you suspected the subform had a different name than the underlying form. With that changed it worked perfectly.
    Thank you-you're awesome.

    nebbia

Posting Permissions

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