>I prefer #2, using a local variable. For a couple of reasons, I guess:
>1. Easy to test from the command window.
>2. Easy to use the view on other forms, reports, etc.
Yes, I think I'll go in this direction and if I need the value more than once, assingnig that to a forms property.
thanks for you input.