Results 1 to 2 of 2
  1. #1
    littlejay is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    2

    Help!How to link a subform to another subform?Thanks!

    I want to create a form that contains two subforms (one-to-many form).
    So that if I change the number in the Record Number Box of Subform1, Subform2 will change automatically.

    Thank you very much for your help! I truly appreciate it!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You will need to do it manually, as the expected structure is form/subform. A couple of methods come to mind. Base the second subform on a query that gets a criteria from the first, and requery it in the current event of the first. Again in the current event of the first, set the record source of the second to an SQL statement that includes a criteria based on the first.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with Subform
    By sneakyfast in forum Forms
    Replies: 1
    Last Post: 02-18-2010, 02:38 AM
  2. Subform Help
    By nkenney in forum Forms
    Replies: 1
    Last Post: 02-17-2010, 04:01 PM
  3. Is It Possible to Tab out of a Subform?
    By skyrise in forum Forms
    Replies: 4
    Last Post: 03-11-2009, 04:01 PM
  4. Replies: 1
    Last Post: 12-10-2005, 04:52 PM
  5. Subform in a Subform and relationships
    By St3ph3n in forum Database Design
    Replies: 3
    Last Post: 12-06-2005, 06:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums