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 a table containing the levels of a building stored as Text. TempVarLVL is set using a combo-box on an unbound form, the record source of which matches is the field [LVL] in the same table the query filters to show a set of records to the user.
The problem comes when I try and allow the user to invert the filter, so that it is not equal (<>) to TempVarLVL.
I tried setting the value of TempVarLVL itself to <>"03" for the not equal setting: the inverse (which works fine) is just 03
Does anyone have any insight here? I've checked the VarType is still a string, CStr() conversion etc. and just can't figure it out.
Thanks in advance.
Oliver
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 a table containing the levels of a building stored as Text. TempVarLVL is set using a combo-box on an unbound form, the record source of which matches is the field [LVL] in the same table the query filters to show a set of records to the user.
The problem comes when I try and allow the user to invert the filter, so that it is not equal (<>) to TempVarLVL.
I tried setting the value of TempVarLVL itself to <>"03" for the not equal setting: the inverse (which works fine) is just 03
Does anyone have any insight here? I've checked the VarType is still a string, CStr() conversion etc. and just can't figure it out.
Thanks in advance.
Oliver