Results 1 to 3 of 3

Thread: Subform Help

  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform Help

    Here's the deal:

    I have a main form. The main form has a tabbed box, with different tabs, and within each tab, there is a subform.

    It's a basic relational database, where there is a list of Attorneys. The attorneys are credentialed in this database.

    The main attorney table contains the following fields:

    FirmID
    SchoolID
    StateBarID

    Then I have seperate tables, and respective forms, for firms, schools, and State Bar Associations.

    What I want to happen is that based on the attorney selected in the parent form, the 'children' will display information applicable to that attorney.

    How can I make my sub-forms react to the attorney selected in the main form?

    Any help would be GREATLY appreciated.

    Regards,
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform Help

    Hi Drk,

    Check the Link Child and Link Master fields on the Subform's properties. Make sure the data source for the Main form includes the ID Field that you assign in the Link Master property.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform Help

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Brilliant! Thanks MarkJ!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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