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

    Data filtering on a form

    Hi. This is my first post here, so thank you very much for all the information provided in this forum.

    I am facing the following problem.

    I have a table, from which I want to create a form. The form should do the following: filter the data based on 6 different criteria – choices: country, city, street etc. These criteria should add one another: for example if the user selects a country = USA, then the cities should be only USA cities (not all the cities contained in the table).

    So, I want the user to be able to filter the data on the form just as he does on the table. Is it possible to do that with comboboxes for example?



    Any ideas?

  2. #2
    Join Date
    May 2010
    Posts
    339

  3. #3
    Sam4 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    2
    Thank you very much!

    I have already done this. I made a cascade of 6th combo boxes. My problem now is this:

    Cmb 1, Cmb 2, Cmb 3, Cmb 4 Cmb 5, Cmb 6 contains the selected data.
    How to show the rest data (12 different values) that correspond to the values selected in comboboxes?
    On a subform? By making a query using the value of comboxes?

    Any ideas please?

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There are free video tutorials at Datapig.

    These 2 deal with cascading combo boxes.
    http://www.datapigtechnologies.com/f...combobox1.html
    http://www.datapigtechnologies.com/f...combobox2.html

    These may give you some insight o how to deal with 6 boxes.

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

Similar Threads

  1. Replies: 6
    Last Post: 11-17-2011, 10:50 PM
  2. Filtering dupe Data in a single field
    By label027 in forum Queries
    Replies: 4
    Last Post: 10-25-2011, 01:18 PM
  3. Unbound form for data filtering
    By alliandrina in forum Access
    Replies: 7
    Last Post: 05-21-2011, 05:19 PM
  4. Filtering/sorting data
    By jemelton in forum Access
    Replies: 5
    Last Post: 06-09-2010, 01:47 PM
  5. Filtering data
    By billybong in forum Access
    Replies: 1
    Last Post: 11-07-2009, 12:20 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