Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dependant Combo Lists (2003)

    I have these Tables:
    PROPERTIES > Fields: PropID, PropName
    UNITS > Fields: UnitID, Unit, PropID
    TENANTS > Fields: TenID, LastName, FirstName, PropID, UnitID

    In Excel we can make the items that appear in a 2nd combo box DEPENDANT on the selection made in a 1st cbo using data validation methods described in Contextures.com
    I want to do a similar process when entering data in an Access Table -- TENANTS.
    I want to select the PropID, then select the UnitID in the next column, but I only want to see the UnitIDs that are associated with the selected PropID for that record.
    Both the PropID and UnitID are combos in the TENANTS table.

    I'm quite new to Access so I need it spelled out step by step.
    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dependant Combo Lists (2003)

    See here http://www.blueclaw-db.com/comboboxlist/ac...opdown_list.htm for a good descriton how to do it, or google "dependent combo boxes access" and there are a ton of examples

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

    Re: Dependant Combo Lists (2003)

    In addition to Zave's reply, see How to synchronize two combo boxes on a form in Access 2002 or in Access 2003. There are also several examples of cascading combo boxes in this forum, e.g. <post:=132,255>post 132,255</post:>.

Posting Permissions

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