Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

2 subforms on 1 form

Discussion in 'Information Technology' started by Francophone, Jul 28, 2006.

Tags:
  1. Francophone

    Francophone
    Expand Collapse
    Guest

    I have a main form where the user can choose a customer. I currently have a
    subform which shows data for that customer and they are linked by the
    customerID.

    Is it possible to insert 2 of the same subforms but with different date
    criteria (ie. last 3 months, last 6 months)? If not, any suggestions on how
    I can do this?

    TIA
     
  2. Loading...


  3. Terry

    Terry
    Expand Collapse
    Guest

    Hi,

    I would guess that using suitable criteria in the recordset of each form for
    the date would return what you need.

    Regards

    "Francophone" <Francophone@discussions.microsoft.com> wrote in message
    news:F0B67530-8ACC-48AF-97CE-CA72FA331B67@microsoft.com...
    >I have a main form where the user can choose a customer. I currently have
    >a
    > subform which shows data for that customer and they are linked by the
    > customerID.
    >
    > Is it possible to insert 2 of the same subforms but with different date
    > criteria (ie. last 3 months, last 6 months)? If not, any suggestions on
    > how
    > I can do this?
    >
    > TIA
     

Share This Page