I grabbed the SQL code from the view and in place of the parameter, I entered the actual value; this was outside of the program.

Now, a little while ago, as I ran the program, I had already grabbed the actual code and then executed that and got the result even with the ThisForm.cProject_No variable. It's just when I run the view within the form, I don't get any results.

And, why would this be working for some time and now, all of a sudden, it just stops working? Either this is a VFP bug, or the data has changed. I checked out indexing and that doesn't seem to be a probem either.