Results 1 to 4 of 4
  1. #1
    Stedman is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2

    List populating based on criteria

    I am totally new to Access, so I apologize for probably not phrasing my question very well.



    I have two tables "Developer" and "Programs." The Developer table just lists the developers (AutoDesk, Pinnacle) The Programs table has two fields listing the developer and the program name (AutoDesk.AutoCAD, AutoDesk.Civil3D, Pinnacle.StudioHD)

    I have a form with drop-down lists for Developers and Programs. When I choose "AutoDesk" from the Developer drop-down list, I only want the programs made by AutoDesk (AutoCAD, Civil3D) to show up in the Programs drop-down list.

    Can someone explain how I can do this? Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,137
    This type of thing?

    Baldy-Cascading Combos
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Stedman is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2
    It took some head scratching and some desk banging, but I finally was able to apply your sample to my form. Thanks a bunch!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,137
    Glad it worked for you.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-12-2011, 02:02 PM
  2. Replies: 7
    Last Post: 11-26-2010, 07:54 PM
  3. Populating attachment field based on text box
    By justinwright in forum Forms
    Replies: 16
    Last Post: 09-22-2010, 08:38 AM
  4. Populating list box with column heading?
    By kawi6rr in forum Programming
    Replies: 1
    Last Post: 08-13-2010, 12:51 PM
  5. Replies: 3
    Last Post: 06-29-2010, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums