Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Add codes to a comb box

    Hi all I got a request from the boss. She wants it to be easier for the users to enter to enter categories into the combo boxes without having to look through a long list.

    This is on a word document but there are 7 categories and connected to them is 28 subcategories. Each Sub belongs to a catelgory.

    So when the user chooses

    Category
    ITP - Individualized Training Plan

    Subcategories

    Academic Assessment
    MER Completion - TANF
    Career Training Plan
    Counseling
    Phone Call


    Category
    Parenting

    Subcategory

    Parenting Training (w/instruction)
    Parenting Home Visits
    Parenting Independent Study - O Travel


    Cateogry
    Job Skills Training

    SubCategory

    Job Skills Training (in office)
    Career Development (Active Job Search)
    Career Training (Workshops)
    Resume Writing


    and the list continues. What I am trhing to do is every time the user chooses a Category in the Second combo box the Subcategories that pertain to that category are all that they see. So they only have those to choose from.

    can anyone help please

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    The concept is called "Cascading Comboboxes." If you Google this term I suspect you'll get a gazillion hits. Here's one tutorial on the subject:

    Cascading Combo/List Boxes - Microsoft Access / VBA insights
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Just a further point, if do not want the users to add there own category or subcategory then set the Limit to List property of the each combo box to Yes.

Posting Permissions

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