Results 1 to 3 of 3
  1. #1
    swalsh84 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36

    Filtering a Subform

    I attached my database below, but here is the general structure. I have a main form (ProjectList) that is for project maintenance (input and editing). I have a second form (ProjectsbyFilter) that I would like to filter the subform (ProjectListDetail). I have searched and tried all sorts of code with no luck. I have 3 comboboxes on the ProjectsbyFilter form that I would like to be the drivers for filtering the subform. I have erased all code that was once in place, and have no turned to the forum here to get some help. There's no need for the subform to filter on multiple combo boxes, but it would be nice if it's doable.



    Much appreciation!

    Edit: My database was too big to bring in, so any suggestions on how to do this would be helpful. Thanks.
    Last edited by swalsh84; 06-23-2010 at 12:07 PM. Reason: File attachment

  2. #2
    Join Date
    May 2010
    Posts
    339
    You could try compacting it first, then place it in a zip file.

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I have a small sample which filters the subform based on a combo:
    Select a Policy number in the combo box you will see the subform being filtered, if that policy number exist for the Fraudref number of the main form.

    see if this helps you.

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

Similar Threads

  1. filtering
    By nashr1928 in forum Forms
    Replies: 12
    Last Post: 07-01-2010, 06:30 AM
  2. Filtering Madness
    By Kipster1203 in forum Reports
    Replies: 18
    Last Post: 05-25-2010, 10:59 AM
  3. Filtering a Query
    By jbarrum in forum Access
    Replies: 1
    Last Post: 11-20-2009, 03:03 PM
  4. Filtering data
    By billybong in forum Access
    Replies: 1
    Last Post: 11-07-2009, 12:20 PM
  5. Replies: 0
    Last Post: 08-17-2008, 12:19 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