Welcome to SPN

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

Sign Up Now!

making fields in a form dependant on each other

Discussion in 'Information Technology' started by Waynef, Oct 27, 2005.

  1. Waynef

    Waynef
    Expand Collapse
    Guest

    How can I use the selection in one fiels combo box to determine the content
    of another fields combo box in my form?
     
  2. Loading...

    Similar Threads Forum Date
    Partition 1947 - The Making Of Refugees History of Sikhism Mar 18, 2015
    Making The Change With Hope & Faith - Sikh Advocate Prabhjot Singh, Md Sikh Youth Mar 11, 2015
    Heritage Sikhs making Their History in Malaysia History of Sikhism May 18, 2013
    Inspirational Making a Difference: A School for Girls in Kenya Videos Mar 25, 2013
    Canada Star-struck’ security and limo drivers? Businesses complain TOIFA staff are making racist demands Breaking News Mar 18, 2013

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    With a filter that refer to the value in the first combo.
    In the RowSource of combo2 add a filter to combo1

    Select FieldName From TableName Where FieldName = Forms![Formname]![ComboName]
    =========================================
    On the after update event of combo1 run the code
    Me.Combo2Name.Requery

    To refresh the List of combo 2
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Waynef" wrote:

    > How can I use the selection in one fiels combo box to determine the content
    > of another fields combo box in my form?
     
  4. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    I think you meant a set of cacaded ComboBoxes.

    See The Access Web article:

    http://www.mvps.org/access/forms/frm0028.htm

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Waynef" <Waynef@discussions.microsoft.com> wrote in message
    news:2D047901-B6B3-45A3-96B2-68953A7EBB04@microsoft.com...
    > How can I use the selection in one fiels combo box to determine the
    > content
    > of another fields combo box in my form?
     

Share This Page