• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Recent content by omwoods

  1. O

    Storing Filter criteria in a TempVar

    Sorry for the late reply, I've been out at meetings. That certainly appears to be the way to do it: thank you for your help! I've kept the tempvars on the AfterUpdates for the moment as they help restrict the combos (which have independent queries as their record source) to values that are...
  2. O

    Storing Filter criteria in a TempVar

    The annoying thing is it worked so simply (one criterion for each field) for the is equal to criteria; it's the is not equal to criteria that's giving me grief: when someone suggested it would be a useful enhancement to the application to exclude certain criteria I thought it would be reasonably...
  3. O

    Storing Filter criteria in a TempVar

    Nigel, Thank you for the reply. It certainly got me thinking differently, and the use of Nz() was a classic example of Occam's razor. I can replicate your method with a single field and corresponding False/True criteria rows, but I can't get it to work with multiple fields being filtered at...
  4. O

    Storing Filter criteria in a TempVar

    Word doc with screen shots included in the attachment as further explanation. Failing that, I'll have a crack at copying out of the front end to give a accdb file as illustration. Cheers, Oliver
  5. O

    Storing Filter criteria in a TempVar

    Hello All, After much searching of forums, the internet in general and help files, I have yet to find a reason why my use of tempvars is inconsistent when used in filtering a query. My query criteria is IIf(IsNull([tempvars]![TempVarLVL]),[LVL],[tempvars]![TempVarLVL]) This criteria filters...
Top Bottom