Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link 2 Subforms (Access 2003)

    Is it possible to link 2 subforms so that when I click in the record of the first subform it displays all the records that belong to the selected item in the selected subform.
    Thanks for any help or suggestions.

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Link 2 Subforms (Access 2003)

    It's pretty easy -
    step 1 Put a text box on the main form, this does not need to be visible. set its control source to be the field on the first subform. eg - =Subform1.Form!SupplierID
    step 2 use this textbox as the Link Master Field on the second subforms.

Posting Permissions

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