Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    forms/subforms (Access '97)

    <img src=/S/butterfly.gif border=0 alt=butterfly width=15 height=15> Hi, I've built a form with a subform. Now every time I add a new subform to the form it duplicates the form. So instead of one form with 2 or more subforms, I have as many forms as I do subforms. How do I get it to just be one form with multiple subforms. The form's Plan Code is linked to the subform's Initial/Date. So the one plan code can be used for the multiple subforms and the inital/date will be different to have multiple subforms. Sorry if that is confusing detail. I have a one to many relationship but the form is being duplicated with each subform added... I want to know how to just have one form and multiple subforms. Thanks <img src=/S/butterfly.gif border=0 alt=butterfly width=15 height=15>

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

    Re: forms/subforms (Access '97)

    Let's try to get the terminology straight first. You say that the "form" is duplicated. I can hardly believe that you would have multiple forms in the database window. Do you mean that if you scroll through the records of the main form, each record occurs multiple times? Or something else? If so, please explain.

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: forms/subforms (Access '97)

    HansV, I am sorry... you are correct it is causing multiple records. 1 form w/ subform... the record is being duplicated as many times as there are subforms. This is my first time building a Database and I had to start where someone else left off... so please forgive me for using the wrong terms. I'm trying though.... Thanks for all your help. You are AWESOME!!!!!!

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

    Re: forms/subforms (Access '97)

    You don't have to apologize, we all have had to learn. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> But I had to ask in order ot understand what the problem was.

    When you create a main form with one or more subforms, you must take care to distinguish the record source of each.

    The record source of the main form should only contain the data needed in the main form; if you include data for the subforms in the record source of the main form, you'll get the behavior you describe. So check carefully what the record source of the main form is, and if necessary throw out what you don't need in the main form. If you can't solve it, post back with details about the record source of the main form.

Posting Permissions

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