Results 1 to 2 of 2
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    299

    Datasheet Filter with Check Boxes

    I have a form that opens in datasheet view. The operators like to click on a column heading, then Home, then Filter. They get a list of check boxes with each unique value in the column and check/uncheck the rows they want to include/exclude. Routinely, they do the same thing with a second, third, fourth and more columns. I don't think there is a practical limit.



    I recently applied a filter to the form to limit the rows that appear in the initial datasheet view. Now, with the filter, they can click on one column, then Home, then Filter and they get the same check box of values to include/exclude. However, if they go to a second column and do the same thing, they don't get the check boxes. I have used a filter within the RecordSource and I've tried putting the filter in a RecordSource query. In each case I get the same result.

    I would like to be able to apply a filter to the form and still let the user pick multiple columns to further filter the datasheet.

    I have tried this with Access 2000 and 2007 databases with the same result.

  2. #2
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    299
    Open database, pick Office Button (Upper left), then Access Options, then Current Database. Near the bottom of the screen under "Filter Lookup Options...", check all three options... wallah, it works. Eddie

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

Similar Threads

  1. Filter by Form: Check Boxes.
    By tbh7x in forum Forms
    Replies: 0
    Last Post: 08-18-2010, 09:15 AM
  2. Cascading combo boxes in datasheet view
    By Hjava in forum Forms
    Replies: 1
    Last Post: 06-28-2010, 06:02 PM
  3. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  4. synch 2 combo boxes in datasheet view
    By kapplers in forum Forms
    Replies: 2
    Last Post: 11-09-2009, 09:09 AM
  5. check boxes
    By chiefmsb in forum Forms
    Replies: 1
    Last Post: 11-14-2006, 02:22 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 - Senior Forums