Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Link Master/Child Fields (Access 2003/SP 1)

    How do you link Master/Child Fields on a report/subreport? Can that only be done with code? I know that I used to be able to do it on the property sheet. (I used to have Access 2000) There is a picture on this link how I know I used to do it.

    http://www.wopr.com/cgi-bin/w3t/showthread...ew=&sb=&o=&vc=1

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

    Re: Link Master/Child Fields (Access 2003/SP 1)

    To see the Subform or Subreport Wizard when you place a subform or subreport, the Control Wizards must be active: the button with the magic wand on the Control Toolbox must be "on" or "down".

    If you have already created the subform or subreport with Control Wizards off, you can set the Link Child Fields and Link Master Fields properties as follows:
    - Open the main form / report in design view.
    - Click once on the subform / subreport.
    - Activate the Data tab of the Properties window.
    - Click in the Link Child Fields or Link Master Fields box.
    - Click the Builder button (the ... button on the right hand side of the box).
    - Select fields from the dropdown lists or click Suggest...

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Link Master/Child Fields (Access 2003/SP 1)

    Thanks a lot. That 'one' click is what I was forgetting. Actually in design view on the main report, I just right-clicked on the subreport.

Posting Permissions

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