Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    4

    Question Unanswered: Linked Combo boxes

    Background.

    The wife asked me to capture our grocery shopping info, simple enough. Create a few tables, a Form and Report. Well, I am stumped. I may have designed it wrong and that is why I am having a problem. I have a few tables. One table has major grocery categories ( produce, meat etc. ). The second table is a sub class of the first table in that pork is a meat and apple is a fruit. Another table
    added the types for table 2, i.e. Granny Smith is an apple, bacon is a type of pork which is under meat. I designed the Form with combo boxes so that I could create a record without a lot of keystrokes. The problem is, if I select grocery in the first combo box, I only want to see in the second combo box, items that are related to groceries. In the third box I only want to see items that are related to apples.

    I tried to use queries as the data source but I am having some problems selecting the "previous/upper" combo box selection. I used a straight query and the results were displayed in a table, not the combo box. I then tried adding the DLookUp function to the query to select a sub set. Well the select works but returns zero results and it is in a table format.

    I want to be able to use the selection made in the previous combo box as part of a filter to reduce the amount of data for the next combo box. I have been in and out the Access programming in the past few years. I am relegated to Access97. Had a system problem and Access2003 is missing some files and I cannot find the install CD. Not sure what info you need.

    I have searched the Access forum but I could not see any way to sort within returned results to fine tune the search. Too many results to read in a life time

    Thanks.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The problem is, if I select grocery in the first combo box, I only want to see in the second combo box, items that are related to groceries. In the third box I only want to see items that are related to apples.
    Ok, so in the second combo box, you need to have the Row Source have a criteria that references the first combo box and so on. To do so you'd need a reference to something like:

    WHERE fieldname = forms!formname!combobox1

    HTH
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'm sure there's something about linked lists in the code bank...
    George
    Home | Blog

Posting Permissions

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