Thanks for that, Mike. Yeah, I usually set a local variable to the form prop beforehand (besides, i've had examples in the past where the SQL refuses to recognise a form prop). I had done as you suggest first, but got the error, so I had reverted back to the form prop in trying to trace the bug.
Doesn't explain the crazy filter though, does it?
Cheers
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.