Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    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
    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.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Jerusalem, Israel
    Thanked 1 Time in 1 Post

    Re: Dependant Combo Lists (2003)

    See here for a good descriton how to do it, or google "dependent combo boxes access" and there are a ton of examples

  4. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    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