Welcome to SPN

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

Sign Up Now!

How do i do criteria on a drop down box

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

  1. Grant

    Grant
    Expand Collapse
    Guest

    ive made a drop box with all car makes and now i want to make a model drop
    box so when you select you make (Ford for example) when youwent to choose the
    model it would have all fords models.
     
  2. Loading...

    Similar Threads Forum Date
    Criteria: When She Deserves to be Raped Hard Talk Dec 21, 2012
    Sikh News Punjab mulling change in pass criteria in board exams (Outlook India) Breaking News Dec 3, 2007
    Opinion U.S. Air Force Academy may drop ‘God’ from oath Breaking News Oct 29, 2013
    World Germany drops its longest word: Rindfleischeti... Breaking News Jun 4, 2013
    Pacific Terror charges against Kiwi Sikh leader dropped Breaking News May 31, 2013

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    Try this link as it gives a detail method of doing this

    http://support.microsoft.com/kb/97624/en-us



    --
    Wayne

    If you feel this answer has been useful please check the "was this post
    helpful" so I get some feedback. Thanks.



    "Grant" wrote:

    > ive made a drop box with all car makes and now i want to make a model drop
    > box so when you select you make (Ford for example) when youwent to choose the
    > model it would have all fords models.
     
  4. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Grant:

    That sounds right to me.

    This is sometimes called "drill down" or "cascading combo boxes".

    There are two ways I can suggest to do this.

    1. On the click event of the Makes combo box, write the SQL for the Models
    combo box so it filters for the selected model.

    2. Have the query for the Models reference the Makes combo box so it
    filters similarly.

    This presumes a proper data structure, which you did not discuss.

    A problem arises if a make and model have already been selected, and the
    make is subsequently changed. This would almost certainly give you a
    make/model combination that is invalid. The click event of the Make combo
    box should set the value of the Model combo box to null.

    In some circumstances, other than make/model, it is possible the lower level
    combo (your model) could have the same values for multiple cases of the
    value in the primary level combo box. This would be like having Pinto for
    both Ford and Chevy. Probably won't happen for automobiles, but does happen
    in many other cases. In this case, I usually check whether the lower level
    combo value is valid for the new primary level combo's value, and null it
    only if it doesn't exist.

    That is, I hope, a modest primmer on how this can be done.

    Tom Ellison


    "Grant" <Grant@discussions.microsoft.com> wrote in message
    news:88747E6A-6163-4265-859A-8BC0A1E42644@microsoft.com...
    > ive made a drop box with all car makes and now i want to make a model drop
    > box so when you select you make (Ford for example) when youwent to choose
    > the
    > model it would have all fords models.
     

Share This Page