Results 1 to 2 of 2
  1. 12-02-2009, 05:51 AM #1
    aletrindade
    aletrindade is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2009
    Posts
    1

    Checkbox filter on a form

    Hi!



    I have a table and a Checkbox field called FFA_Status.



    I would like to filter in my form only Checked items:



    I don't know how to use Filter options and what does Filter On Load means...

    I've tried: [FFA_Status]="Yes"... Not working

    THANKS!
    Reply With Quote Reply With Quote
  2. 12-02-2009, 06:22 AM #2
    blcknite
    blcknite is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    3
    i am using MS Access 2003 but when i use yes or no as filters

    YES = -1

    NO = 0

    this may help.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Filter data on a form from another control on the same form
    By WonkeyDonkey in forum Forms
    Replies: 2
    Last Post: 11-25-2013, 10:56 AM
  2. Checkbox in continous form
    By senthilrg in forum Access
    Replies: 11
    Last Post: 12-05-2009, 08:49 AM
  3. Form Combobox filter
    By westcoastbmx in forum Forms
    Replies: 0
    Last Post: 10-20-2009, 11:27 PM
  4. Filter Form records with Combo Box????
    By jgelpi in forum Forms
    Replies: 0
    Last Post: 05-19-2009, 07:05 AM
  5. How to open a form with filter applied?
    By rkm360 in forum Access
    Replies: 1
    Last Post: 03-18-2009, 09:27 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums