Results 1 to 4 of 4

Thread: Form Filtering

  1. #1
    Join Date
    Oct 2014

    Unanswered: Form Filtering

    I have a form called "Benefit Tracking" that has some information on it along with two check boxes: 401Enrollment and BenefitsEnrollment. How do I filter the form so that only people that have either check box unchecked appear? Or, how do I not show people that have both check boxes checked? I appreciate any help that someone could provide.

  2. #2
    Join Date
    Oct 2014

    Form Filtering

    I have a form, called Employee Benefits that I would like to filter to only show employees who have not signed up for either Medical or Dental or both. Medical and Dental are check boxes on the form. How do I do this?

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    there's various options
    1) with 401 and with benefits
    2) with 401 and without benefits
    3) without 401 and with benefits
    4) without either
    0) show all rows

    ...for that I'd use say a list box (or a combo if you are limited on vertical space)
    in the list/combo's on click event work out what the user requested and apply a filter

    psudeocode is:-
    select case index (where index is the value of the item selected in the list box
    case 1:
    me.filter = "401column = true and benefitscolumn=false"
    ....insert others as required
    case 4:
    me.filter = "401column = true and benefitscolumn = true"
    case else
    me.filter = "1=1" 'an age old SQL dodge that is valid and will return all rows
    end select

    you could expand the list to say 401 checked only, or 401 unchecked (ignoring benefits etc...)
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Oct 2014
    Click image for larger version. 

Name:	Access.png 
Views:	8 
Size:	37.3 KB 
ID:	15903

    What am I doing wrong???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts