• Filter (Access 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Filter (Access 2003)

    Author
    Topic
    WSrobinr
    AskWoody Lounger
    April 15, 2007 at 12:28 am #441618

    I have a form with 2 subforms. I have set up a command button so that a user can filter – but it only allows a filter on the main part of the form not the 2 subforms. How can I set it up so that it would also allow the user to filter by either of the subforms?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSJezza
      AskWoody Lounger
      April 15, 2007 at 9:14 am #1060905

      Hi Robin

      Just seeking clarity here, so excuse the further questions. Can I assume:

      1) The macro/VBA code to the button is in a module?
      2) In the subforms will you be filtering on similar fields?

      and as a note of opinion, without seeing your design, I am just a little worried having filters on these areas , how do you clear them after use?

      Reply | Quote
    • WScharlotte
      AskWoody Lounger
      April 15, 2007 at 3:27 pm #1060916

      In addition to Jerry’s questions, what is it you’re trying to filter. If the subforms are linked by master/child links, they’re filtered automatically by any filter applied to the parent form. If you’re trying to filter the parent from the subform, why?

      Reply | Quote
      • WSrobinr
        AskWoody Lounger
        April 15, 2007 at 8:30 pm #1060954

        I guess I didn’t explain this very well. I have a form that has a command button that the user can click on and activate the Filter by Form option. From the form the user can select anything on the main form and click apply filter and it filters for the main form and the 2 subforms. What I would like the user to be able to do is click the command button then be able to click into either of the 2 subforms make a selection or set criteria then click apply filter.
        thank you in advance to all that can help

        Reply | Quote
        • WSJezza
          AskWoody Lounger
          April 15, 2007 at 9:09 pm #1060960

          In what format are the subforms?

          If you have then as a single or continuous form you can put a filter button on them but if it is datasheet, you can’t

          Reply | Quote
          • WSrobinr
            AskWoody Lounger
            April 15, 2007 at 10:20 pm #1060976

            Yes, they are datasheet view.

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 15, 2007 at 10:28 pm #1060978

              Why do you need a command button for the Filter By Form option? There is a toolbar button for it. You could create a custom toolbar for your form and subforms with the Filter by Form button (and others) to make sure that it is always available.

              Reply | Quote
            • WSrobinr
              AskWoody Lounger
              April 15, 2007 at 11:41 pm #1060985

              I thought it would be easier for the person using the DB to have a button that they could click. I can do the toolbar but I’m still not sure how to get the filter on subform. When I try – it just filters the subform.
              thanks
              Robin

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 15, 2007 at 11:57 pm #1060988

              Filter by Form affects only the form that has the focus when you invoke it. If the focus is on the main form, the main form will be filtered, and if the focus is on one of the subforms, that subform will be filtered (without any effect on the main form). If you want to filter the main form at the same time as the subform, you’d have to create your own form for it, and write lots of code.

              Reply | Quote
            • WSrobinr
              AskWoody Lounger
              April 16, 2007 at 12:04 am #1060989

              Thanks Hans – don’t know how to write code so will have to do with what I have.

              Reply | Quote
    Viewing 1 reply thread
    Reply To: Filter (Access 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.