Recent content by omwoods

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...

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...

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...

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

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...