Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    23

    Cool Unanswered: How do I run a query based on two subforms?

    Hi All,

    I have a form with 3 subforms (each a combo box). I want to run a query from a combo box (on the 3rd subform) based on the selections from the 1st and 2nd combos. For example:

    On my 1st combo, I can choose electrical, plumbing or carpentry.

    If I choose electrical on my 1st combo, I can choose power, cabling or consulting (I have this set up already). I choose cabling

    I have 3 choices on my 3rd combo box (customers, vendors, research). If I choose customers at this point, I want to run a based on the previous two combo boxes to give me all electrical cabling customers.

    Can you help me?

    Thanks,
    Johnny

  2. #2
    Join Date
    Dec 2002
    Posts
    3

    Re: How do I run a query based on two subforms?

    Originally posted by MountJohnny
    Hi All,

    I have a form with 3 subforms (each a combo box). I want to run a query from a combo box (on the 3rd subform) based on the selections from the 1st and 2nd combos. For example:

    On my 1st combo, I can choose electrical, plumbing or carpentry.

    If I choose electrical on my 1st combo, I can choose power, cabling or consulting (I have this set up already). I choose cabling

    I have 3 choices on my 3rd combo box (customers, vendors, research). If I choose customers at this point, I want to run a based on the previous two combo boxes to give me all electrical cabling customers.

    Can you help me?

    Thanks,
    Johnny

    Are you trying to force the value list in each combo box to be dependent on the selected value in the previous combos, or are you trying to specify criteria to limit the results in a query dynaset?

    JDS

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    this looks like it'll be a challenge, i'll see if i can come up with anything

    so you've got a list of job types
    a list of jobs and
    then you want to find all of the customers, vendors or reaschers that use the above boxes
    Last edited by m.timoney; 12-17-02 at 06:15.
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    is this the type of thing you want?
    Attached Files Attached Files
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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