Results 1 to 2 of 2
  1. #1
    icloudy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2013
    Posts
    2

    Table to Form Filters

    Please be gentle.

    I have a table with some 500 records containing some 40 columns.
    I have a form designed for ease of creating a new record and editing existing records.

    When in Table
    I use my various filters to breakdown and select the records I wish to work with.

    When I switch back to Form, the records area as before with not filters
    100% of the records still showing.

    I wish to use the table lay out for setting up my filters (just how my brain works)
    Then switch to Form in order to work on the selected records and edit them as required.
    Afterwards knowing that the edits will update the table.

    Who do you get the filtered records show up in form? Help

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    I don't know of a way to make that happen automatically. Normally, if you want to filter a form, you put fields with the filter categories on the header of the form, and then those act to filter the body.

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

Similar Threads

  1. Multiple filters on a continuous form
    By Ray67 in forum Forms
    Replies: 3
    Last Post: 01-26-2013, 10:57 PM
  2. Filters in one form affecting another...
    By Dominaz in forum Access
    Replies: 1
    Last Post: 10-25-2011, 04:55 PM
  3. Form Filters Help
    By JeffG3209 in forum Forms
    Replies: 1
    Last Post: 05-22-2011, 10:31 PM
  4. Replies: 1
    Last Post: 02-12-2011, 09:06 PM
  5. Creating Filters on a Form
    By Nixx1401 in forum Access
    Replies: 4
    Last Post: 02-27-2010, 05:32 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