Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Unanswered: Help w/ filtering subform by using 3 combo boxes

    I am looking to filter a query (which is derived from a table) by drilling down on the data by using 3 combo boxes as the filtering criteria; ultimately displaying the final filtered data in the subform on the same form page as the combo boxes. I have been back and for looking for solutions on how to accomplish this with not much success. This is a cry for help!

    Thanks in advance for any help provided.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    What did you try so far? The database you posted does not contain a single line of code.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    By the sound of it you ought to look up cascading combo boxes
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you design is a mess
    get it normalised BEFORE proceeeding further, it will just cause more problems if you don't
    Fundamentals of Relational Database Design -- r937.com
    The Relational Data Model, Normalisation and effective Database Design

    ferinstance
    the vehicle manufacturer should be a table of their own, and use the primary key of that table as the foreign key in acest. same for models opf vehicle, and ANYTHING else that contains repeating data

    use the DISTINCT keyword to bring in unique values for your combo boxes

    also avoid using spaces in table, query and column names. you can set 'human friendly' captions in the table design if you feel you must.
    whilst you are at it be aware of MS Access reserved words.. words or symbols you should not use for table, query and column names
    Last edited by healdem; 02-06-14 at 05:01.
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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