Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

connecting table/query filters to forms

Discussion in 'Information Technology' started by bryanhise@gmail.com, Jul 28, 2006.

  1. bryanhise@gmail.com

    bryanhise@gmail.com
    Expand Collapse
    Guest

    Does anybody know how to connect table filters to form filters
    dynamically?

    For instance, I filter my table/query of say 100 records and my filter
    returns 20. Currently, my form shows all 100 records. I can enter
    design view, re link all of my forms to the current search, and then
    all of my forms will return the 20 filtered records. I then have to
    repeat these steps each time I perform a search/filter, which is often.
    This method is quite cumbersome and it seems that there must be a more
    efficient way to do this.

    Any tips?

    Thanks in advance,

    Bryan
     
  2. Loading...

    Similar Threads Forum Date
    Need Help - Connecting with the Guru... Questions and Answers Mar 19, 2013
    Buddhism The Zen Brain: Connecting Meditation and Neuroscience Interfaith Dialogues Sep 19, 2011
    Sufism Sufism: Connecting Mankind Interfaith Dialogues Feb 16, 2011
    SikhRI Connecting with the Divine Light Sikh Organisations Jul 23, 2009
    Connecting The Dots In History Essays on Sikhism Mar 21, 2009

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can read the Filter property from your table like this:
    Currentdb.TableDefs("MyTable").Properties("Filter")
    and then assign it to the Filter property of your form, and set FilterOn to
    True.

    It might be easier to create a form where the user can select criteria from
    various boxes, and apply the filter to the form directly. For an example,
    see:
    Search form - Handle many optional criteria
    at:
    http://allenbrowne.com/ser-62.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <bryanhise@gmail.com> wrote in message
    news:1152623591.860650.249250@35g2000cwc.googlegroups.com...
    > Does anybody know how to connect table filters to form filters
    > dynamically?
    >
    > For instance, I filter my table/query of say 100 records and my filter
    > returns 20. Currently, my form shows all 100 records. I can enter
    > design view, re link all of my forms to the current search, and then
    > all of my forms will return the 20 filtered records. I then have to
    > repeat these steps each time I perform a search/filter, which is often.
    > This method is quite cumbersome and it seems that there must be a more
    > efficient way to do this.
    >
    > Any tips?
    >
    > Thanks in advance,
    >
    > Bryan
     

Share This Page