Here's another one...
I have a '1 to many' form that uses a grid filled by a view. Everything works fine until a record is selected that returns an empty view. The grid shows up empty, but when the next record is selected (that normally should have maching records in the chold table), the grid comes up empty again. Every time before I requery, my search variable is set immediately before to a value that I have already checked. Everything works fine again the next time the form is run. What am I missing?