Results 1 to 2 of 2
  1. #1
    DatabaseIntern is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    20

    Apply Filter similar to Field Filter

    I am working on a db that links modules to microcontrollers and vice versa (both are many to many as an individual module can be used in many microcontrollers, and a microcontroller can contain many modules), I am trying to find a way to filter results so that I can easily display what material is linked to a particular module.microcontroller (IE: say I select Module 1, it filters a list of all microcontrollers containing it. Or if i was to choose Microcontroller A it would provide a list of all modules it uses). This is easy to do when looking in table form, as I can simply pull down the filter button and check "Microcontroller 1" and the table will filter itself accordingly. What I want is to know if there is an easy way to put this funtion into a form to be displayed in a listbox/textbox etc... It seems like it would be easily doable, but I cannot seem to figure it out.

    To Clarify: I want to select a certain example from a combobox, and then have the resulting related microcontrollers showed. This would be the exact same filter as if i selected that filter from the main table.



    Here is the column filter option- Note*: This provides the results that I want when used, but I dont want to have to apply filters in this manner.
    Click image for larger version. 

Name:	ColumnFilter.png 
Views:	4 
Size:	32.2 KB 
ID:	8046

    Here is the specific Query that the below form is based on. I would in general like to do this on the main table show above, but this may be useful in this exact situation. *Selecting OK in this picture would sort the data so that only the modules used in Aguilla 20 would be displayed. or whichever checkboxes I had selected.
    Click image for larger version. 

Name:	ColumnFilter2.png 
Views:	3 
Size:	42.5 KB 
ID:	8048

    Here is an idea of what I want (this is a form based on the above query, it doesn't work as desired right now...)

    Click image for larger version. 

Name:	WantedFilter.png 
Views:	5 
Size:	24.6 KB 
ID:	8047

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,028
    Options:

    1. cascading (dependent) combo/list boxes. http://datapigtechnologies.com/flash...combobox2.html

    2. apply filter to the form http://datapigtechnologies.com/flash...tomfilter.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. How to filter dates using an apply filter code.
    By Jgreenfield in forum Reports
    Replies: 4
    Last Post: 11-15-2011, 01:38 PM
  2. Apply Filter 2 criteria not applying
    By ahightower in forum Forms
    Replies: 4
    Last Post: 07-28-2011, 03:31 PM
  3. Option button to apply filter
    By catguy in forum Programming
    Replies: 4
    Last Post: 06-23-2011, 12:10 PM
  4. Replies: 5
    Last Post: 10-06-2010, 07:28 PM
  5. Apply filter command
    By miziri in forum Forms
    Replies: 6
    Last Post: 01-21-2010, 02:22 AM

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 - Senior Forums