Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2006
    Thanked 0 Times in 0 Posts

    Categories and Sub Categories (2003)

    I am trying to create a form so that when you choose a category from the category drop down field the sub category dropdown updates to the sub categories for the category selected. I have tried a few different ways to accomplish this, but to no avail.

    Thank You

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Categories and Sub Categories (2003)

    Welcome to Woody's Lounge!

    You can change the Row Source of the subcategories combo box in the After Update event of the categories one. See MSKB article ACC2000: How to Synchronize Two Combo Boxes on a Form. This article (which also applies to Access 2003) contains a link to download a demo database with a working example.
    Alternatively, you can set the Row Source of the subcategories combo box to a query with a parameter that refers to the categories combo box. See MSKB article ACC2000: How to Create Synchronized Combo Boxes.

    You can also search for cascading combo boxes in this forum.

    Post back if you have further questions.

Posting Permissions

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