>I just tried again and the two data elements that should come up on the screen still do not appear. The view still does not produce the desired data, as it once did. As I said, I can run the same SQL code externally and do get the desired result. Is the some kind of fluke in the views that does this?
I just took a closer look at your code, and saw that you use "ThisForm....". I believe that this can cause trouble. Perhaps you can try to replace with a private variable?
BTW, how can you run the view from the command window, if it depends on ThisForm....?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)