Search results

  1. E

    Filtering all but Fields with no DAte in a case statement

    Brilliant thank you so much vbaInet Thats a great call it works great was it supposed or only in SQL done wonders for my form so thank you very much and thanks for all your tips on F1 and Ctrl G. i look forward to trying it out. Ps... one simple thing that has been bugging me because i am sure...
  2. E

    Filtering all but Fields with no DAte in a case statement

    Thankyou Very much i will try AND i will start to Give my Check boxes meaningful names. Think i have not so far because i expect them not to work !!! BTW where is the best place for looking up syntax, available functions etc on the web ... takes me time to find what the syntax is for the...
  3. E

    Filtering all but Fields with no DAte in a case statement

    Hi guys am trying to Filter all records that have been archived in a form. I know i can just build the form on a query excluding them but i want to be able to see and not see them. So i wrote this code - Private Sub Check259_AfterUpdate() Select Case Me!Check259.Value Case True...
Back
Top Bottom